REGEX -- separate raw data into 6 columns

[TomBock]

Hi:

I would like to use REGEX to delimit my single source column. As a picture is worth a 1000 words, please see attached JPG illustrating the "After" output.

Based on the sample data (XLSX) file, what regular expression would turn the "Before" data into the "After" output?

Thanks,
Tom

 

[PhilipMannering]

You don't need regex to do this. You could do,

[PhilipMannering · Accepted solution]

But this regular expression in the Regex Tool set to parse will also work,

(\D+),(\d+/\d+/\d{4})(\d+)\*([\d.]+)\*(\d+).(\d+).

[ShankerV]

Hi @TomBock 

One way of doing this.

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

Many thanks

Shanker V

[TomBock]

@PhilipMannering -- thank you... both of your solutions work great.   I appreciate your assistance.  

[TomBock]

@ShankerV -- thank you as well for the solution.   'Very much obliged.