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.
Solved! Go to Solution.
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:]]', '')
This has helped solve my problem. Thank you greatly for the help.