Liquid Studio 2020
Delimiters (Flat File Writer Wizard)

Delimited File Configuration

If your file was delimitated, then the next screen allows you to define the rules used to read each field.

The delimiters break the fields, its possible to select a number of delimiters, but in practice the file normally only uses a tab or a comma.

The "Fields are enclosed in quotes" property means that if the first char within a field is a quote then the value is considered to be everything up to the next quote. This makes it possible for a field to contain the delimiter character. If the field also needs to contain a quote char then 2 quote chars in a row are interpreted as a single quote.

Data Field 1 Value Field 3 Value Field 3 Value Field 4 Value
abc,123,xyz abc 123 xyz
abc,"123",xyz abc 123 xyz
abc,"1,23",xyz abc 1,23 xyz
abc,1,23,xyz abc 1 2 xyz
abc,"1""23",xyz abc 1"23 xyz
abc,"1"23",xyz ERROR
abc,1"23,xyz abc 1"23 xyz
abc,"1""2,3",xyz abc 1"2,3 xyz


See Also