hi,
I need help to create formula to identify column that contains valid code IMAGE*:ORIG. e.g IMAGE1:ORIG, IMAGE2:ORIG
Sample column
Regex_Match([Object], “.*IMAGE\d+:ORIG.*”) should work!
Contains[field],"contacted") OR Contains[field],"features") OR .... and so on
I need to identify if the column has a code IMAGE with any values that contains ORIG
@Johmz
You can use it in a formula Contains(Field,text) or in filter tool
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
Hi @Johmz
Your formula needs to be tweaked slightly:
REGEX_MATCH([OBJECT],".*IMAGE\d+:ORIG.*")
@Johmz You didn’t type it the way I did!
@Johmz let us know if it worked
Thank you. Its now working.
Great! Please accept the response(s) that helped as a solution then.
Hello all,
I have a similar problem but regarding multiple criteria. I'm trying to figure out how to filter out the data based on multiple keywords using the contains formula. In this example, I'm looking for any of the cells that contain the text of contacted, features, or listened. I don't have the text analytics features, so I'm hoping there is a way to pull fields with the keywords via a formula. Any insight would be greatly appreciated.
Flawless! Thank you!
