Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
New content is available in Academy! You may need to clear your browser cache for an optimal viewing experience

Challenge #20: List Parsing

Highlighted
Asteroid
 
Highlighted
Asteroid
Spoiler
Chantelbbr_0-1577080507832.png
Highlighted
Asteroid

Great Regex Practice. This one took me a while.

 

JonathanW_0-1578354588640.png

Highlighted
Asteroid

Phew!!! finally was able to create the solution. This is longest I've taken to solve any weekly challenge. Used a log of RegEx to get the output. When compared to the posted solution, I realized that my approach was complicated, none the less, was able to solve it.

 

Spoiler
Challenge_20_Mdodrajka.PNG

Highlighted
Alteryx Certified Partner

solution attached

Spoiler
Capture.PNG
Highlighted
Asteroid

 

RegEx!   I managed to parse a few more phone numbers from the address field than the solution did. - terry10

 

challenge 020 diff ss.PNG

Spoiler
challenge 020 ss.PNG

 

Highlighted
Alteryx Partner

This one was painful! 

 

Spoiler
wc020.PNG


My final RegEx for the address/phone parse. 
^(.*(?:, [A-Z]{2}(?: {1,2}(?:\w{5,6}|\d{3} \d{3}))?(?:[- ]\d{4}|-?)?))? *((?:\w{3}[-.]?\w{3}[-.]?\d{4,5}|\d-\d{3}-\d{3}-\d{4}|\d{12})(?: EXT \d{2,4}| ?x ?\d{1,4})?)?$

RegEx tester session: https://regex101.com/r/bHrkbs/3

Highlighted
Alteryx Partner
Spoiler
キャプチャ.JPG
Highlighted
Asteroid

Ouch!

Highlighted
Asteroid

Hardest Challenge for me yet