Split Column

[Jaspal80]

I have a column with the below data 

Column

1111(AO-D 20221021, AD 20221021, PD 20221021)

I want to split the data in to multiple column as shown below

No	AO-D	AD	PD
1111	20221021	20221021	20221021

How can I do this?

[DataNath]

@Jaspal80 are you able to provide a little more info here - is this a consistent pattern/format and you'll always be splitting the data into 4 columns with these names? If so you can use RegEx in Tokenize mode which will extract x occurrences of a pattern (in this case more than 1 number, 4 times, which looks to be what you want to pull out). We then just use a select to remove the original column and set the names:

If there's variation and perhaps different names etc then we'll need more information and a wider range of examples. Hope this helps to get you started.

[PhilipMannering]

I'm not sure how dynamic you need it, but here's a solution using the Text To Columns Tool,

[Jaspal80]

Thank you so much. This works

[Jaspal80]

Thank you for your help with this.