I am new to Alteryx and I am using the column to text parse and I am splitting one column to two. The delimiter that is used is a : and it is bringing that delimiter with the second column after the split. How to i get rid of the :
Sample:
Original data
Z13 : Doe,John |
after Text to Column
Z13 | : Doe,John |
having trouble losing that colon
Solved! Go to Solution.
Hi @dcrigger
I tried with this data and didn't see the same behavior. Could you share a screenshot of the configurations you used? See attached.
Thank you for the responses,
When I used ":" as the delimiter the newly created cells had trailing and leading spaces. So I tried to use \s in the delimiter as well ":"
So i have trailing spaces or : in the cells.
That did it thank you