Parse String after character

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

Workflow

Regex

Parse

Accepted answers

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

Workflow Results Results

Possible to share sample data in text format?

Hi @ponraj sorry. There you go.

The data is under the DownloadData column

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

Workflow Results Results

@ponraj Thanks for that!

Works like a charm.