Text file

Below is the interface for setting up text file source, where, besides specifying the file name, fields to be selected, primary key, and performing analysis on fields, you also configure character set, separator and sorting field:

Check for Orderliness: Check whether data in the current text file source is ordered by the selected fields, which are already ordered。

Import the first row as field names: Use the first row as field names at import. Use _1，_2,… as field names when the option isn’t selected. The option is by default checked.

Remove quotation marks: Delete quotation marks from both sides of each data item, including items in headers, but leave quotation marks within data item alone.

Use double quotation marks as escape character: Use the standard Excel escaping rule to transform the two pairs of double quotation marks to one pair while leaving other characters alone.

Keep leading and trailing spaces: Keep white spaces at both sides of each data item; by default, they will be automatically deleted.

Select all fields, set gender as the primary key, check Ordered for it, select Import the first row as field names, and click Check for Orderliness: