How to trim and combine data in Alteryx

I am trying to trim all the value after a specific special character and combined rest of the value with underscore.please find the description as below:

Input : at1:x,at2:y,at3:z........

Output:. x_y_z

I am trying with text to column but unable to achieve desired output.please note that input will be having dynamic length

Workflow

Parse

Accepted answers

messi007

@Avishek1,

Please see below:

Attached the workflow,

Hope this helps,

Regards

Concat_20210301.yxmd

mot

Sure. See attached. I hope this helps. Best.

tokenize.yxmd

All comments

mot

Hi @Avishek1,

Will you have only x y z? Or can it be more than that? If you could give more information, it would be helpful. Best.

messi007

@Avishek1,

Please see below:

Attached the workflow,

Hope this helps,

Regards

Concat_20210301.yxmd

Avishek1

Hi @mot thanks for responding it will be dynamic based on input length

mot

Hi @Avishek1,

You can use tokenize especially if the length is unknown.

Screen Shot 2021-03-01 at 9.55.20 AM.png

I have attached the workflow. I hope this helps. Best.

tokenize.yxmd

Avishek1

Is it possible to only get desired result in output which is column 2

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15875

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703