Extract with regular expression

Extract chunks from a column using a regular expression. Note that regular expressions are not anchored: ([0-9]*) will capture 232 in val-232.

Options

Regular expression

Once the input column is filled, use Find with Smart Pattern to help generate a regular expression.

Capture groups

Use named or unnamed capture groups to extract distinct chunks into several output columns. Unnamed capture groups use the (pattern) syntax and place matches into numbered columns. Named capture groups use the ((?<groupname>pattern) syntax and place matches into named columns using the group name.

Example, unnamed group:

  • Cell value: id-37-X234

  • Pattern: id-([0-9]*)-([0-9A-Z]*)

  • Output column prefix: extracted_

  • Result: extracted_1=37 extracted_2=X234

Example, named group:

  • Cell value: id-37-X234

  • Pattern: id-(?<numidentifier>[0-9]*)-(?<identifier2>[0-9A-Z]*)

  • Output column prefix: extracted_

  • Result: extracted_numidentifier=37 extracted_identifier2=X234

Found column

Enable this option to create a column name found containing a boolean to indicate whether or not the pattern matched.

Extract all occurrences

Enable this option to extract multiple matches of a group into one array.