CONTAINS

[Johmz]

hi,

I need help to create formula to identify column that contains valid code IMAGE*:ORIG. e.g IMAGE1:ORIG, IMAGE2:ORIG 

Sample column

[Johmz]

I need to identify if the column has a code IMAGE with any values that contains ORIG

[alexnajm · Accepted solution]

Regex_Match([Object], “.*IMAGE\d+:ORIG.*”) should work!

[OTrieger]

@Johmz 

You can use it in a formula Contains(Field,text) or in filter tool

[Johmz]

It working but the result is not match based on the syntax. it resulted to "ESCALATED" even there's a IIMAGE1:ORIG

If

REGEX_MATCH([OBJECT],"*IMAGE\d+:ORIG")

then "AGREE"
else "Escalated"
Endif

[Luke_C]

Hi @Johmz 

Your formula needs to be tweaked slightly:

If

REGEX_MATCH([OBJECT],".*IMAGE\d+:ORIG.*")

then "AGREE"
else "Escalated"
Endif

[alexnajm]

@Johmz You didn’t type it the way I did!

[alexnajm]

@Johmz let us know if it worked

[Johmz]

Thank you. Its now working. 

[alexnajm]

Great! Please accept the response(s) that helped as a solution then.