I have a column with the below data
I want to split the data in to multiple column as shown below
How can I do this?
@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.
I'm not sure how dynamic you need it, but here's a solution using the Text To Columns Tool,
Thank you so much. This works
Thank you for your help with this.
