Challenge #4: Date Parsing

[steven4320555]

A lot of try and error to learn some regex.

Spoiler

16/17

I had some difficulties in controlling 1-2 digits. My understanding is /d{1,2} suppose to mean 1 or 2 digits, but it is not working as I thought. 

Something highly related to data-time. I used to use dd mm yyyy... now, I know % 

"Specifiers always begin with a percent sign (%), followed by a case-sensitive letter. The data must include at least a two digit year." ref:

https://help.alteryx.com/11.0/Reference/DateTimeFunctions.htm

[Kale_Malcom]

Spoiler

my regex is no where near as elegant as the provided solution, but as a regex beginner I was happy to get mine to work and get the dates right.

[Anood]

my solution  

[igorp]

Spoiler

Thanks for this one!

I took a bit less RegEx-heavy approach but it still works 🙂

[grossal]

Time to work on these challenges 😃

Spoiler

Not really clean this time.

[cneivam]

Spoiler

I used an interesting expression for months ==> (Jan(?:uary)?|Feb(?:ruary)?|Mar(?:ch)?|Apr(?:il)?|May|Jun(?:e)?|Jul(?:y)?|Aug(?:ust)?|Sep(?:tember)?|Oct(?:ober)?|Nov(?:ember)?|Dec(?:ember)?)\s(\d+)\s(\d\d\d\d)

Hello everybody. Very interesting this one!

Follow attached my solution!

Regards.

Neivam

[Sudha8990AI]

Good Exercise for date parsing.

Thanks,

Sudhakar S 

[Chirag09goa]

Great to get exposed to RegEx. Very limited ways, other then RegEx, to efficiently parse the string and extract date especially with multiple format

Solution Attached

[KevinTang]

Done

[Ben_Jeffreys]

My submission