Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
IDEAS WANTED

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback
We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.

Challenge #188: Difficult, but not im-parse-able

Alteryx Partner

A bit of regex to the rescue

Spoiler
dsmdavid_0-1580981975130.png
8 - Asteroid

Wahoo

7 - Meteor

My solution:

 

Spoiler
jallen297_0-1581432643351.png
7 - Meteor

Solution attached.

Alteryx Partner

Well this was pretty messy, but i got there, haven't RegEx'd in a long time...

8 - Asteroid
Spoiler
188_Amin.PNG
Alteryx Partner

finished long time ago, the workflow may need some optimization, but I don't have the nerve to revisit the challenge again, haha

5 - Atom

Once you get the RegEx right, the rest is easier. I find .txt files are difficult to work with in general.

 

Spoiler

My RegEx code:

\|\s*?\d+\s*\|\s*(\d{3}-\d{2}-\d{5})|(\d{10})\s*(\u{2})\s*(\d{4}-\d{2}-\d{2})\s*(\d{4}-\d{2}-\d{2})\s*(.*?)\s*([A-Z][0-9])\s*(.*?)\s*\|
Challenge_188_RegEx.JPGChallenge_188.JPG

  

 

17 - Castor

atcodedog05_0-1586103742858.jpeg

 

Spoiler

This is my solution

atcodedog05_1-1586103769252.png

 

 

12 - Quasar
Spoiler
Capture.PNG