If Contains - with multiple factors without having to use OR with each one

[kas]

Hello,

I could write this using OR for each criteria, but there's quite a few and hoping there is an easier way.

Tried:  if CONTAINS([URL] IN ("ANB", "TAX","Support","SSP","SOC","PS","Annuities","MMSDRM","IFL","Fraud","AQA","FANB","FAS","DQ","DMS","DIClaims","Claims","ANB") then 'TRUE' ELSE 'FALSE' ENDIF

Rather than having to do:

if Contains([URL], 'ANB") or contains ([URL]. 'tax') or contains...etc for each value.

is this possible?

Thank you,

Kim

[nagakavyasri · Accepted solution]

@kas This is possibly one solution:

[kas]

@nagakavyasri 

That's a good thought...will take a close look at your option.

Will let you know :)

Thank you,

Kim,

[kas]

@nagakavyasri 

This worked perfectly, thank you 🙂