How to trim and combine data in Alteryx

[Avishek1]

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

[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 · Accepted solution]

@Avishek1,

Please see below:

Attached the workflow,

Hope this helps,

Regards

[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.

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

[Avishek1]

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

[mot · Accepted solution]

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