CustomSeparated
| Input | Output | Alias |
|---|---|---|
| ✔ | ✔ |
Description
Similar to Template, but it prints or reads all names and types of columns and uses escaping rule from format_custom_escaping_rule setting and delimiters from the following settings:
- format_custom_field_delimiter
- format_custom_row_before_delimiter
- format_custom_row_after_delimiter
- format_custom_row_between_delimiter
- format_custom_result_before_delimiter
- format_custom_result_after_delimiter
note
It does not use escaping rules settings and delimiters from format strings.
There is also the CustomSeparatedIgnoreSpaces format, which is similar to TemplateIgnoreSpaces.
Example Usage
Inserting Data
Using the following txt file, named as football.txt:
Configure the custom delimiter settings:
Insert the data:
Reading Data
Configure the custom delimiter settings:
Read data using the CustomSeparated format:
The output will be in the configured custom format:
Format Settings
Additional settings:
| Setting | Description | Default |
|---|---|---|
| input_format_custom_detect_header | enables automatic detection of header with names and types if any. | true |
| input_format_custom_skip_trailing_empty_lines | skip trailing empty lines at the end of file. | false |
| input_format_custom_allow_variable_number_of_columns | allow variable number of columns in CustomSeparated format, ignore extra columns and use default values for missing columns. | false |
