Splitting Columns by Dynamic Delimeter

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:

Screenshot 2023-03-07 at 2.52.10 PM.png

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.

Datasets

Transformation

Preparation

Expression

Data Investigation

Accepted answers

binu_acs

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

Regex_070323.yxmd

All comments

binu_acs

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

Regex_070323.yxmd

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.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703