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