Issues with Regex Match

mystasz

I have the below text input:

With this formula......

I expect it to look like this:

But instead, I'm getting this:

Any idea what I may be doing wrong? Thanks in advance.

Regex Match.yxmd

Regex

Common Use Cases

Accepted answers

Matthew

this should work, you just need to add some wildcards to your pattern:

REGEX_Match([Record ID], '.*EAP.*|.*RTR.*|.*LPP.*')

All comments

MarqueeCrew

@mystasz ,

I took a slightly different approach with this:

IF 
	(Contains([Record ID],"EAP") OR
	 Contains([Record ID],"RTR") OR
	 Contains([Record ID],"LPP")) AND 
	(Contains([Record ID],"LQL") OR
	 Contains([Record ID],"PRP")) 
THEN "Level 1, Level 2"
ELSEIF
	Contains([Record ID],"EAP") OR
	Contains([Record ID],"RTR") OR
	Contains([Record ID],"LPP")
THEN "Level 1"
ELSEIF
	Contains([Record ID],"LQL") OR
	Contains([Record ID],"PRP")
THEN "Level 2"
ELSE Null()
ENDIF

Cheers,

Mark

Matthew

this should work, you just need to add some wildcards to your pattern:

REGEX_Match([Record ID], '.*EAP.*|.*RTR.*|.*LPP.*')

MilindG

mystasz

Thank you all for solutions!! @Matthew 's solution worked best for me as my actual dataset has about 200+ different record IDs. It was easier to concat with the .*? and plug into the formula.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703