Split Data into multiple column

[Labhesh]

I wanted to split data into multple column as given example in Row(1) of attached workbook.

the problem is data column has multiple values to split on and i recently start working on alteryx so i have no idea how to do it.

FIle is attached below.

[ShankerV · Accepted solution]

Hi @Labhesh 

One way of doing this.

(.+)\s+(\d{1,2}/\d{1,2}/\d{4})(\d+)\*(.+)\*(\d+)\[(\d+)\] 

 

Many thanks

Shanker V

[binuacs · Accepted solution]

@Labhesh Another way of doing this (dynamic)

[Labhesh]

HI @ShankerV , @binuacs Thanks for the solution.it worked .👍

can you guys help me the little description in the regex used. That would be thankful.

[ShankerV]

Hi @Labhesh 

Please make use of the below links.

https://community.alteryx.com/t5/Videos/Introduction-to-Regular-Expressions/td-p/258578

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/RegEx-Examples-12-Handy-Use-Ca...

Also in addition to that, 

Hope this helps!!!

Many thanks

Shanker V