Edit as Table: <file_name> Format dialog
If a text file containing delimiter-separated values (e.g. CSV, TSV) is open in the editor, this dialog opens when you select the Edit as Table command.
Specify how your delimiter-separated values should be converted into table format.
When working on the conversion settings, use the table preview in the right-hand part of the dialog.
Item | Description |
---|---|
Formats | Select your file format and check the table preview. If you haven't achieved the desired result yet, adjust the settings. |
Value separator | Select or type the character used for separating individual values. |
Row separator | Select or type the character that should be treated as a row separator. |
Null value text | The text to be used as a value if a cell contains null (an unknown value). |
Add row prefix/suffix | Row prefix and suffix are character sequences which in addition to the row separator indicate the beginning and end of a row. If necessary, click the link and specify the row prefix and suffix in the fields that appear. |
Quotation | Each line in the area under Quotation is a quotation pattern (see Quote values). A quotation pattern includes:
If there is more than one pattern, the first of the patterns is used. Use To start editing an existing pattern, just click the pattern of interest. |
Quote values | Specify in which cases the values should be quoted (i.e. enclosed within quotation characters). |
Trim whitespaces | If this check box is not selected, the Unicode whitespace characters that precede and follow the value separators are treated as parts of the corresponding values. If this check box is selected, the corresponding whitespace characters are ignored or removed. |
First row is header | If this check box is selected, the first row is treated as containing column names. The settings that appear under Header Format have the same meanings as the ones above but are applied to the first row. |
First column is header | If this check box is selected, the first column is treated as containing row names. |