Data tables and Net. Data tables can be built from flat files. In order to make the transformations between the tables and flat files, you must define the mapping between columns in a table and records in a flat file. Delimiters provide a method for defining how portions of records in a flat file can be separated and mapped to columns in a table, and how columns in a table can be mapped to records in a flat file. Use this transformation when your table is made up of one column.
Data maps each line in the corresponding flat file onto a single row in the table.
In this case, the new-line character in the flat file is the only delimiter used. Data writes row data to a line in a flat file, it places the delimiter string as a separator between the column entries. Data rebuilds a table from a flat file, it uses the delimiter string to determine how much of each line to place in a column of the table. In this case, the regular new-line character separates the lines in the flat file that correspond to rows in the table, and the delimiter string separates the items within a single line. For read operations, the delimiter separates the contents of the file into rows and columns of a table.