Perform a regular expression search, returning rows that match a given pattern, either anywhere in the whole extract, or limited to a specific field.
Example 1

Example Input 1
dim_A | dim_B | metric_1 |
aaAA | DDD | 111 |
BBB | EEE | 222 |
CCC | AAAA | 333 |
Example Output 1
dim_A | dim_B | metric_1 |
aaAA | DDD | 111 |
CCC | AAAA | 333 |
Example 2

Example Input 2
dim_A | dim_B | metric_1 |
aaAA | DDD | 111 |
BBB | EEE | 222 |
CCC | AAAA | 333 |
Example Output 2
dim_A | dim_B | metric_1 |
CCC | AAAA | 333 |
I Ain't Afraid of No Code!
Example 1[
[
"search",
{
"subtable": null,
"pattern": "AA$",
"_comment": null
}
]
]
Example 2
[
[
"search",
{
"subtable": null,
"pattern": "AA$",
"field": "dim_B",
"_comment": null
}
]
]
param str subtable: Name a subtable in which output will be stored (will create subtable where necessary).
param str field: Field to be searched with regex.
param str pattern: Search expression as regex.
param str comment: A comment that will appear in the Transformation UI.
Comments
0 comments
Article is closed for comments.