Parsing Data to Respective Column

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:

Parsing Output.PNG

Parsing Rank Country.xlsx

Datasets

Parse

Accepted answers

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.

All comments

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.

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

Quick Links

Tags

This months top contributors

atcodedog05 19598

Qiu 15867

MarqueeCrew 13708

apathetichell 13703