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. For write operations, the delimiter indicates the end of a value in a table row and column. Data passes the delimiter to the FFI as a Net.
Data uses the new-line character as the delimiter and ignores any requested delimiter.
Undesirable changes to a file can occur if you use a different delimiter for write operations than for read operations. Data writes the file with the new delimiter. The maximum length of a delimiter is 256 characters.