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, it's 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