Extract RegExp
Matches the specified regular expression against the content of the specified column.
To split the 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 the keyboard_arrow_down icon to access the following commands:
- Filter Matching
- Filter Not Matching
- Select Matching
- Select None