Find Text
Description
This activity extracts specific text from the column values using a regex pattern specified by the user.
Input
Data only
Output
Transformed data
Configuration Fields
- Columns To Find The column from which text should be extracted.
- Pattern The regex pattern used to extract text.
- Output Columns Prefix Prefix for new columns created after extraction.
- Include Original If enabled, includes the columns from the previous activity; otherwise, only the extracted output column is provided as output.
Sample Input
| ID | Description |
|---|---|
| 1 | This contains ABC and XYZ |
| 2 | Find CODE inside this text |
| 3 | No pattern matches here |
| 4 | Extract INFO and DATA points |
| 5 | SAMPLE test for extraction |
Sample Configuration
Sample Output
| ID | Description | Column_1 | Column_2 |
|---|---|---|---|
| 1 | This contains ABC and XYZ | ABC | XYZ |
| 2 | Find CODE inside this text | CODE | |
| 3 | No pattern matches here | ||
| 4 | Extract INFO and DATA points | INFO | DATA |
| 5 | SAMPLE test for extraction | SAMPLE |