Skip to main content

Table.split_to_columns

split_to_columnscolumndelimitercolumn_count on_problems

Group: Conversions
Aliases: parse, tokenize

Documentation​

Creates a new table by splitting the chosen column of text, by the specified delimiter 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.

Returns - Returns a Table with the newly split columns and the original removed.

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, reporting them as warnings by default.

Errors​

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