Parse Regular Expression Not Working as Expected

[taliatest]

Hi Everyone,

Can anyone advise me on why this regular expression is not working as expected for the two department values highlighted in yellow? It is working for all other departments. Ideally, these two would follow suit and break everything out into three separate columns (examples seen on records 679-683 in image attached)

Image attached below

[atcodedog05]

Hi @taliatest 

Can you share the data before the regex tool and regex. So that we see how the other data looks and help you out.

[apathetichell]

can you also copy and paste that formula in the regex tool -> the short is that line is not conforming to your formula - so regex is saying there isn't any way to parse it to get it to fit your schema. I can't make out why - and @atcodedog05 - who should be sleeping at 2:45 a.m. - also can't make out why.

[atcodedog05]

@apathetichell 

Hahaha 😂

Was up on some work 😅

[flying008 · Accepted solution]

Hi, @taliatest 

If possible, please paste the 3 lines of text where you resolved the exception here. I suspect that the spaces and parentheses here may not be the standard characters you see, so the parsing failed.

Department	RegExOut1	RegExOut2	RegExOut3
Unum Finance Enablement (Alex Anderson - NO Chargebacks / 0846)	Unum Finance Enablement	Alex Anderson - NO Chargebacks	846
Unum Regulatory Affairs Legal (Matt Fuss / 9325)	Unum Regulatory Affairs Legal	Matt Fuss	9325
No department
TL AI Change (Nikki Hensley / 5005)	TL AI Change	Nikki Hensley	5005

[EN6924]

(.+)\s\((.+\/)\s(\d+).+ 

- Also working.