Column to Text carries the Delimiter with the 2nd column

[dcrigger]

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

[Luke_C]

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.

[Qiu]

@dcrigger 
Agree with @Luke_C , the ":" should give the desired output.

By any chance, you are using a "\s" as the delimiter since it will give the result you are presenting.

[dcrigger]

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.

[Luke_C · Accepted solution]

@dcrigger 

I see, try it with the below configurations, that should resolve both issues:

[dcrigger]

That did it thank you