REGEX

[suby]

Hi All,

How to Filter only for Record 2 using REGEX.  i,e ABC - XYZ.

I want to exclude other records if it has ABC - XYZ with other values.

Attached sample workflow.

[aatalai · Accepted solution]

@suby put this into a filter tool 

REGEX_Match([Name],"\s*ABC - XYZ\s*")

Let me know how you get on

[suby]

Thanks what if I have to find a way to find record 2,4,6 

[aatalai]

@suby there are only 3 records, in the file you uploaded, or are you talking about more generally only wanting records 2,4,6 - if so use the select records tool

[suby]

Hi Sorry uploading the revised  WF.

In this case I want to find the records where it has got ABC  that is records 2,4,6. since this is just a sample data and in real word we have more combinations and it would be hard to put filters on it.

And even we have the ABC - **** Combination of records in 1,3 & 5 if that's the case then we want to exclude these records from output.

[aatalai]

@suby update the filter to as follows REGEX_Match([Name],"\s*ABC - \w{3}\s*")

[suby]

Thanks for your solution one final thing is we have a pattern of  ABC - DEF******** like this as well but in you logic  it restricts to 3 letters.

([Name],"\s*ABC - \w{3}\s*")

[aatalai · Accepted solution]

try this

REGEX_Match([Name],"\s*ABC - \w+\s*")

[suby · Accepted solution]

Great that works... Thanks