Alteryx REGEX Tool Formula Help

[BobbyQ]

Hi I can't figure out why this REGEX Tool formula isnt working in Alteryx when I have tested it out with success on a regex builder program.
Not sure if REGEX_MATCH in Alteryx functions differently somehow? Essentially I am trying to get the last occurrence of a string in a concatenation delimited by spaces.

Desired result: "CK*1140*H*QK*FF*RXQ*25/32*DNDCDDL*DDDD*DDDOSPOLY*0*1111"

Any help would be greatly appreciated. Thank you

[jrlindem]

@BobbyQ do you need to specifically use REGEX?  You might, in your real world need, but if not...  here's an idea to try out.

If you only just need the last string, regardless of it's format and how many concatenations there are, consider reversing the string, parsing it, and reversing back the first parsed response like this (and attached):

It's "creative" but it has its place, especially if you don't know how many partitions there will be in the concatenation.

Hope this helps, -Jay

[binuacs]

@BobbyQ , you can also try a different regex to get the result