community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

Parse String after character

Asteroid

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:

Capture.PNG

I am using the regex tool however, I am unable to get clear extract out of this.

 

Help would be deeply appreciated.

 

Harshad

Quasar

Possible to share sample data in text format? 

Asteroid

Hi @ponraj sorry. There you go.

The data is under the DownloadData column

Alteryx Certified Partner

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 :)

 

 

Quasar

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

 

workflow.PNGWorkflowResults.PNGResults

Asteroid

@ponraj Thanks for that!

Works like a charm.

Labels