So I have downloaded data and cleansed it a bit from a sports website. Each row contains all data about a player.
The data I am interested in is:
1. Player Name
2. Nationality
3. OVR
4. POT
5. Position
6. Team
from this:
I am using the regex tool however, I am unable to get clear extract out of this.
Help would be deeply appreciated.
Harshad
Solved! Go to Solution.
Possible to share sample data in text format?
Hi @ponraj sorry. There you go.
The data is under the DownloadData column
Hey @HBarge
This is a messy one, but it's always a good idea to split the html into rows first and then work your way through with RegEx to extract what you need..
I've started you off with some examples, have a go to see if you can figure out the rest of it :)
@ponraj Thanks for that!
Works like a charm.