topic Re: Split Text to 2 Columns with repeated delimiter in Alteryx Designer Desktop Discussions

Split Text to 2 Columns with repeated delimiter

Adityasa — Thu, 13 Jun 2024 21:30:54 GMT

Hi,

I have a column that looks like this below:

XYZ - Mumbai - Apple

ABC - Delhi - Ball

DEF - Kolkata

GHI - Chennai

And I want to split the above column into two columns:

[Column 1] [Column 2]

XYZ Mumbai - Apple

ABC Delhi - Ball

DEF Kolkata

GHI Chennai

So I want to use only the first dash as the delimiter. Can someone please guide me?

Thanks.

Re: Split Text to 2 Columns with repeated delimiter

mpennington — Tue, 23 Mar 2021 05:07:49 GMT

You just need a RegEx Parse:

(.+?)\s-\s(.*)

Re: Split Text to 2 Columns with repeated delimiter

AngelosPachis — Tue, 23 Mar 2021 06:09:09 GMT

Hi @Adityasa ,

Besides the method provided by @mpennington , you can also use a text to columns tool which is slightly easier to configure if you are not familiar with RegEx. You just have to define the delimiter and then the number of columns you are looking to create.

Cheers,

Angelos