alteryx Community

# Weekly Challenge

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

Also available in | Français | Português | Español | 日本語
###### IDEAS WANTED

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

## Challenge #4: Date Parsing

11 - Bolide

Solution attached.  I wasn't familiar with RegEx, so I needed to do some research and peak at the solution.  I found using a single formula after the RegEx parse to be simpler.

Ken

12 - Quasar

Weekly challenge 4 done.

Spoiler

Formula tool:
IF REGEX_Match([Field_11], "\d+-\u{3}-\d{2}")
THEN DateTimeParse([Field_11], "%d-%b-%y")
ELSEIF REGEX_Match([Field_11], "\d+-\u{3}-\d{4}")
THEN DateTimeParse([Field_11], "%d-%b-%Y")
ELSEIF REGEX_Match([Field_11], "\d+-[\u\l]+-\d{4}")
THEN DateTimeParse([Field_11], "%d-%B-%Y")
ELSEIF REGEX_Match([Field_11], "[\u\l]{3} \d+, \d{4}")
THEN DateTimeParse([Field_11], "%b %d, %Y")
ELSEIF REGEX_Match([Field_11], "[\u\l]+ \d+ \d{4}")
THEN DateTimeParse([Field_11], "%B %d %Y")
ELSE NULL()
ENDIF
8 - Asteroid

I really enjoyed working on this solution because I appreciate the advantages of regular expressions. On my first try, I did a long version of columns using additional regex tools; on my second try, I used a slightly different approach with a single regex tool. Somehow on this last try, I ended up parsing a T on column 6.

I guess that I should have used the two or more digits option instead of forcing the two and four digit year onto their own columns.

8 - Asteroid

That was a pretty good solution @MarqueeCrew

11 - Bolide

Awesome challenge to use the RegEx tool.  Solution is attached.

16 - Nebula

I love my regex. Still not up to @MarqueeCrew's standards though...

Spoiler
20 - Arcturus
Thanks for the mention!
Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and restart. Order shall return.
10 - Fireball

This link from @AlexKo helped me understand the 'RegEx' Thank you Alex for such a comprehensive resource.
Attached is the 4th challenge solution.

7 - Meteor

My solution attached. was a good refresher to regex

Spoiler
12 - Quasar

This was a good exercise to reinforce my regex skills.  My solution looks similar to others I found here.

Derek