Delimited files, often referred to as “CSV” or text files, represent tables of data in a simple text format.
Rows are separated by newline characters, or by newline and carriage-return pairs.
Columns within rows are separated by delimiters. The delimiters supported by Ajilius are comma, tab, semi-colon and vertical bar (‘|’). All rows must contain all columns, although empty columns may be represented as consecutive delimiters.
Text fields containing delimiters must be enquoted using single (‘) or double (“) quote characters.
Where a text field contains a character used as a delimiter, that character must be preceded by an escape character, typically backslash (\). If the text field contains the escape character, it must be preceded by another escape character (ie, ‘\\’).
Delimited files must have column names contained in the first row of the file.
The file may be encoded in any format supported by Ajilius (link).
Detection of encoding, delimiters, quotation and escape characters is automatically performed on file access. You don’t need to specify anything other than the file name.
Ajilius. Flexible delimited file formats.