Column to Text carries the Delimiter with the 2nd column

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

Preparation

Accepted answers

Luke_C

@dcrigger

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

All comments

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.

ColumnSplit.yxmd

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.

New Workflow4.yxmd

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.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15878

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703