Parse String Data

[Mario36]

I have a column of data which has to be split into columns, I did try a RegEx but couldn't get the right expression. What is the best approach to solve this ?

10-31-2015@11213@100@1.36

101@12545@09-23-2015@25.8965

18.1436@12-04-2016@85485@102

103@67218@9.34@11-05-2014

12.2365486@05-27-2019@104@84651

This is the result I want to achieve.

A	B	C	D
100	11213	1.36	10-31-2015
101	12545	6.58	09-23-2015
102	85485	4.23	12-04-2016
103	67218	9.34	11-05-2014
104	84651	12.23655	05-27-2019

[atcodedog05 · Accepted solution]

Hi @Mario36 

You can do something like this.

Hope this helps : )

[Mario36]

@atcodedog05  Brilliant as always. Thank you . This is an amazing solve.

[atcodedog05]

Happy to help : ) @Mario36 

Cheers and have a nice day!