string fields

[alwisb]

In the below scenario I need to separate records where UNIT ID field contains only alpha characters using filter tool. How should i write the logic in custom filter?

eg:

UNIT ID       Volume 

PPHE          20

8834           5

6754           10

7864            9

CCIS           7

BCFS          15

[atcodedog05 · Accepted solution]

Hi @alwisb 

You would need regex_match for this. Here is how you can do it.

Workflow:

Hope this helps : )

[alwisb]

wow that was spot on! Thank you. i had no clue of such stuff.

[atcodedog05]

Happy to help : ) @alwisb 

Cheers and have a nice day!