Issues with Regex Match

[MysticalAz]

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. 

[MarqueeCrew]

@MysticalAz ,

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 · Accepted solution]

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

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

[MilindG]

[MysticalAz]

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.