Search for specific characters in a cell with conditions

[vishtrack]

Hi, could you kindly help me with this problem?|I am looking to find for a specific value in cells that contains multiple values separated by comma. The value should contain only US or UK, all others should be ignored. If cell contains US Comm then consider but if it contain Aus then ignore.

Ideally, the last 4 rows should be considered since it contains the acceptable values- UK, US. How do I solve this please? Thank you

Programs

US, UK, GR, Aus

Aus, GR

US Comm, KB, MR

UK, MR

US Comm, UK

US

UK

US, UK

[BRRLL99]

Regex tool configuration

• Field to Parse: Programs
• Regex Expression: \b(?:US|UK)\b

[gawa · Accepted solution]

hi @vishtrack 

When you have multiple values in a single cell, try to parse into rows by Text to Column tool or Regex Tool. By doing so, you will be able to manage further data process more easily with least number of tools. 

Here is the solution for your case. This WF returns the rows consisting of only US/UK/US Comm. If you want to customize check logic, review the expression of Formula tool.

[vishtrack]

This worked like a charm, thank you! :)