Skip to main content

DB_Table.parse_to_columns

parse_to_columnscolumnpatterncase_sensitivityparse_valueson_problems

Group: Conversions
Aliases: regex, split, tokenize

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.