Search for specific characters in a cell with conditions

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

Tips and Tricks

Preparation

Accepted answers

Gawa

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.

1244027_gawa.yxmd

All comments

BRRLL99

Regex tool configuration

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

Gawa

hi @vishtrack

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.

1244027_gawa.yxmd

vishtrack

This worked like a charm, thank you!

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15878

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703