Skip to main content

Table.split_to_columns

split_to_columnscolumnsdelimitercolumn_counton_problemserror_on_missing_columns

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​

  • columns: The name or index of the column(s) 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.
  • error_on_missing_columns: If True, an error is raised if a specified column is not found. If False, the missing column is ignored.

Errors​

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