Alteryx Designer Discussions

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

Parsing Data to Respective Column

mohdhafiz
6 - Meteoroid

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

 

 

5 REPLIES 5
paulfound
11 - Bolide

Hi @mohdhafiz

 

PaulFound_0-1600930508161.png

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.

atcodedog05
21 - Polaris

Hi @paulfound 

 

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

jdunkerley79
16 - Nebula
16 - Nebula

HackerRank has a decent course: https://www.hackerrank.com/domains/regex

 

And there are some decent online tools like https://regexr.com and https://regex101.com

 

 

atcodedog05
21 - Polaris

Thanks @jdunkerley79 

 

I will post a question please reply over there so that the post is easily findable.

paulfound
11 - Bolide

To be honest I've just learned through trial and error. 

 

Not sure how advanced this is either to be honest, its repetition really and long, some better RegEx'ers may have a better way of . 

 

I like to use online RegEx testers like regex101.com (This doesn't do Perl, Alteryx uses Perl) I find that you can mess around and find ways to capture and group the data.

 

Hope this is of some help. 

 

Labels