Challenge #4: Date Parsing

[dillon_bok]

Spoiler

needed a little help with regex but figured it out after that

[CaraI]

Rocked my first Advanced challenge ... might not be pretty, but got the job done.

[jsdeter]

Solution to Challenge

[JDelgado]

I gotta say - this parsing text to find a date somewhere within the string, allowing for variation in date formats, has me stumped...

Without giving away too much, can someone give me a hint on how they did the parsing? (I don't want to look at anyone's full solution)...

:-D

JohnD

[ivoller]

@JDelgadosee Regex Tool help

[JDelgado]

That figures... I was never very good at writing regex expressions... thanks!

[JDelgado]

Got it.

I gotta say, I'm not a fan of regex... that being said, through trial and error I got a solution that works.

There is some weirdness going on with the input record that starts with "The best cure for insomnia...

[Gauthier_B]

Done, glad I could put these newly acquired regex skills to use! Solution below.

Spoiler

[LauraScavino]

My first Alteryx Challenge exercise 

Spoiler

 

[TimothyManning]

Spoiler