Data Extractors dialog
To access this dialog:
From the Table Editor or the Result tab of
the Database, JPA or Hibernate console:
Click the Data Extractor button , then Configure Extractors.
From the Database tool window:
Right-click the table or view of interest, select Save To File, then Configure Extractors.
Use this dialog to manage data extractors and their settings.
A data extractor is a named set of settings that define how to convert table data into CSV, TSV and other formats.
Data extractors are applied when table data are copied to the clipboard or saved in a file.
Note that for certain formats (CSV, TSV, HTML and custom formats), it may be useful to define more than one data extractor - each with different settings.
When you select an extractor in the list, you can view and edit the extractor settings in the area to the right.
Use (Alt+Insert), (Alt+Delete), (Alt+Up) and (Alt+Down) to create, delete, and reorder the extractors.
|List of data extractors and examples|
|See an example for:||Initially, each item in the list corresponds to a different target format. Format names are self-explanatory. Below, each of the formats is illustrated with an example. To generate the examples, the following table was used as a source.|
|Comma-separated Values (CSV)||
|Tab-separated Values (TSV)||
|SQL Insert Statements||
|SQL Update Statements||
When generating this example the following settings were used
Value quotation policy: As needed
Initially, there are no custom formats. To add one, click and select Custom-separated Values.
|Title||The name of the extractor. Corresponds to the name of the option in corresponding menus.|
|Include column names||Select this check box if you want the column names to be included.|
|Include row numbers||Select this check box if you want the row numbers to be included.|
For CSV, TSV, HTML and custom formats:
this setting defines how selected range of cells is copied to the clipboard.
If a table is shown transposed, and you copy a range of cells to the clipboard (Ctrl+C), the range is copied transposed (as shown) if the check box is selected, and non-transposed (as in the original table) otherwise.
|Value / line separator||For custom formats: a character or characters to be inserted between the values and at the end of a line (a table row).|
|Line prefix / suffix||For custom formats: a character or characters to be added at the beginning and the end of a line (a table row). The suffix is inserted before the line separator.|
|Value quotation||For custom formats: a character or characters to be added before and after a value.|
|Value quotation policy||
For custom formats: specify conditions for value quotation: