Skip to main content

Table.parse_to_columns

parse_to_columnscolumnpatterncase_sensitivityparse_valueson_problems

Group: Conversions

Documentation

Converts a Text column into new columns using a regular expression pattern. Each match becomes a row in the table. The values of other columns are repeated for the new rows. If there are no marked groups, a single column with whole content of match is added. Otherwise, each group becomes a column (with group name if named in Regex).

Arguments

  • column: The column to split the text of.
  • pattern: The pattern used to search within the text.
  • case_sensitivity: Specifies if the text values should be compared case sensitively.
  • parse_values: Parse any values using the default value parser.

Remarks

Column Names

If no marked group, the new column will have the same name as the input. If the marked groups are named, the names will be used otherwise the column will be named <Input Column> <N> where N is the number of the marked group. If the new name is already in use it will be renamed following the normal suffixing strategy.