regex match on multiple fields for multiple values

[Idyllic_Data_Geek]

Is it possible to do a regex_match of mutiple fields containing multiple keywords?

For e:g can I do . if REGEX_Match([Field 1] or Field 2],".*REALTY.*|.*GROUP.*|.*COLLECTION.*|.*SOCIETY.*") instead of writing if else if?

[atcodedog05 · Accepted solution]

Hi @Idyllic_Data_Geek 

My bad use this formula

IF !REGEX_CountMatches([Field1], ".*\s.*") THEN 'ENT'
ELSE 'Other'
ENDIF

Workflow:

Hope this helps : )