Articles in this section

See more

Select/Cut Fields - "search" (instruction)

Avatar
Tom Sherwood
  • Updated
Follow

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

search_example.png
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

search_example_2.png
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.

Related articles

Comments

0 comments

Article is closed for comments.