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
Solved! Go to Solution.
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.
Hi @mot thanks for responding it will be dynamic based on input length
Hi @Avishek1,
You can use tokenize especially if the length is unknown.
I have attached the workflow. I hope this helps. Best.
Is it possible to only get desired result in output which is column 2