Edit as Table
If a text file containing delimiter-separated values (for example, CSV, TSV) is open in the editor, this dialog opens when you select the Edit as Table command.
Edit CSV in the table view
Right-click inside a delimited text file and then click Edit as Table. Also, you can click the Edit as Table icon in the editor.
In the dialog that opens, specify format settings and click OK.
The dialog has two predefined formats (CSV and TSV) and lets you create a custom format. For example, you may require comma-separated values with semicolons as row separators.
Two tabs for the file become visible: Text and Data. Text presents data in a text format, Data in a table format.
The data editor opens in a separate tab based on the settings you configure. If you want to use different format settings, repeat the previous procedure and open the data editor again.
In the Import File dialog, you can specify import settings for formats with delimiter-separated values. You can use the predefined templates or create a new one.
This dialog lets you specify the settings for converting table data into delimiter-separated values formats (for example, CSV, TSV) and vice versa.
Conversion settings
When you change import settings, the import preview changes correspondingly.
Item | Description |
---|---|
Formats | Select a template that successfully converts the file data into a table. You can change settings of predefined templates or add a new template. To add a template, press Add Format button (). To save changes, click the Save icon and select one of the following options:
Use ,, and to create, delete and reorder the formats; to create a copy of the selected format. |
Value separator | Select or type the character that you want to use as a separator for values. |
Row separator | Select or type the character that you want to use as a separator for rows. |
Null value text | Select or type the text that you want to use if a cell contains the NULL value. |
Add row prefix/suffix | Click the link and type a row prefix and suffix. Prefix and suffix are character sequences which in addition to the row separator indicate the beginning and end of a row. |
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 pattern is used. Use ,, and to create, delete and reorder the patterns. |
Quote values | Select when you want to enclose values within quotation characters.
|
Trim whitespaces | Ignore or remove whitespace characters. If this checkbox is cleared, the whitespace characters are treated as parts of the corresponding values. |
First row is header | Treat the first row as a row that contains column names. |
First column is header | Treat the first column as a column that contains row names. |