Parsing Data to Respective Column

[mohdhafiz]

HI, I am having difficulties on parsing the data where it needed to be parsed to columns. I used the RegEx tools for parsing the data, however my regular expression are not working. I hope you guys can share with me the right expression needed. Attached below are excel file for the original data.Thank you for your help and really appreciated it.

This are the sample output required:

[paulfound · Accepted solution]

Hi @mohdhafiz

Regex: (.*?)\s(.*?)(\d+\.\d+|n\/a?).*?(\d+\.\d+|n\/a)\s+(\d+|n\/a)(.*?)(\d+\.\d+|n\/a?)\s+(\d+\.\d+|n\/a?)

I got rid of any leading .(stops) prior to regex to make life easier.

Let me know how you get on.

[atcodedog05]

Hi @paulfound 

This is amazing. Can you suggest some resources for learning advance level Regex.

[jdunkerley79]

HackerRank has a decent course: https://www.hackerrank.com/domains/regex

And there are some decent online tools like https://regexr.com and https://regex101.com

[atcodedog05]

Thanks @jdunkerley79 

I will post a question please reply over there so that the post is easily findable.

[paulfound]

To be honest I've just learned through trial and error. 

Not sure how advanced this is either to be honest, its repetition really and long, some better RegEx'ers may have a better way of . 

I like to use online RegEx testers like regex101.com (This doesn't do Perl, Alteryx uses Perl) I find that you can mess around and find ways to capture and group the data.

Hope this is of some help.