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:
Planet | r1 | r2 |
---|---|---|
Earth-3 | Earth | 3 |
Mars-4 | Mars | 4 |
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