Open TXT (CSV, TSV, Fixed-width) file

Open a file: open a text file (TXT/TSV/CSV) to load data.

Encoding: choose the file encoding.

Whole File Content As One Column: True to load whole file content as the only column, False will not.

Start At Row: set the data start line.

Delimiter: "," or "|" or "#" or TAB or white space, or custom.

Quoted By: single quotation marks('), or double quotation marks("), or none, or custom.

Has Multi-Line Record: True for record contains line break.

Column Count: if "Has Multi-Line Record", you need set "Column Count" for 1 record.

Field Name In File Header: True for fieldnames (columnnames) in the first line of file content.

Fixed-width text: set "Column Widths" to comma separated numbers, one width per column; the last column takes the rest of each line. Click "Detect" to guess the widths from the file content. Delimiter / Quoted By / Has Multi-Line Record are not used in fixed-width mode.

---