REGEX help

[JohnBell]

I'm trying to get the desired results...see excel sample...

I'm using the RegEx tool...with the expression [^_]+ and output method tokenize...it's close, but since the raw data is inconsistent, I'm not getting the desired result 100% of the time...

Any suggestions from the REGEX experts?

Thanks!

[PhilipMannering]

Hey John,

Since it's always a number followed by an underscore, how about using Parse in the Regex tool and using the pattern: _(\d+)

I think this should work.

[ponraj]

Attaching a workflow for your case. Just see if it helps. 

[MarqueeCrew · Accepted solution]

@PhilipMannering,

I like where you were going with your solution, but the incoming data contains records with a bonus space.

EXPTAS-201708-P-Scrappy Benefit Upgrade Launch_ 27708_x

Should you want to catch these using the Parse, you'll end up needing to modify the expression as:

_\s?(\d+)

This means:  I want to create a group of digits that is preceded by a dash with 0 or 1 spaces after it.

Cheers,

Mark

[JohnBell · Accepted solution]

Thanks everybody!  appreciate it...that did it...

Regards,

John