Skip to main content
Skip to main content

CustomSeparated

InputOutputAlias

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:

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:

SettingDescriptionDefault
input_format_custom_detect_headerenables automatic detection of header with names and types if any.true
input_format_custom_skip_trailing_empty_linesskip trailing empty lines at the end of file.false
input_format_custom_allow_variable_number_of_columnsallow variable number of columns in CustomSeparated format, ignore extra columns and use default values for missing columns.false