Parse String after character

[HBarge]

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

[ponraj]

Possible to share sample data in text format? 

[HBarge]

Hi @ponraj sorry. There you go.

The data is under the DownloadData column

[LordNeilLord]

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 · Accepted solution]

Here is the sample workflow for your case.  Hope this is helpful. 

WorkflowResults

[HBarge]

@ponraj Thanks for that!

Works like a charm.