Splitting Columns by Dynamic Delimeter

[trojan6ixman]

Hi all,

I am new to Alteryx but an avid user of Power Query. I am looking to split a column I have that looks like this:

 

Normally in Power Query I'd split by "/Project-" to just get everything to the right of that text string since that is the real Project ID that I want. How can I manage to do this in Alteryx? I have already split by decimeters "/" and "-" but I'd like a more dynamic way of doing it in case there may be random string characters in the ID itself like $^%. Is there a way to use a wildcard or something to only get what is to the right of "/Project-"? Anything helps, and I'm trying hard to learn! Thanks all.

[binuacs · Accepted solution]

@trojan6ixman This can be achieved with the help of the regex tool

[flying008]

Hi, @trojan6ixman 

By formula, you can use classic function or regex expression:

1- formula by function only:

ReplaceChar(Replace([Project ID], '/Project-', ''), '^$&%_-', '')

2- formula by RegEx expression:

REGEX_Replace(Replace([Project ID], '/Project-', ''), '[^[:alnum:]]', '')

[sparksun]

[trojan6ixman]

This has helped solve my problem. Thank you greatly for the help.