Skip to main content

Extract RegExp

Matches the specified regular expression against the content of the specified column.

To split column regular expression groups are used. Groups are added as new columns.

Example

RegExp: (.*)-(.*)

Data:

Planet
Earth-3
Mars-4

Result:

Planetr1r2
Earth-3Earth3
Mars-4Mars4

To learn more about regular expressions, please visit https://www.regular-expressions.info.

Click on the keyboard_arrow_down icon in order to access the following commands:

  • Filter Matching
  • Filter Not Matching
  • Select Matching
  • Select None