DB_Table.split_to_columns

split_to_columnscolumndelimitercolumn_count on_problems

Group: Conversions
Aliases: parse, tokenize

Documentation

Splits a column of text into a set of new columns. The original column will be removed from the table. The new columns will be named with the name of the input column with a incrementing number after.

Arguments

• column: The name or index of the column to split the text of.
• delimiter: The term or terms used to split the text.
• column_count: The number of columns to split to. If All_Columns then columns will be added to fit all data.
• on_problems: Specifies the behavior when a problem occurs.

Errors

If the data exceeds the column_count, a Column_Count_Exceeded will be reported according to the on_problems behavior.