Challenge #4: Date Parsing

[trjeffries]

Spoiler

[JS1989]

Solution

[witleyn]

[solution]

[TGreen]

Challenged solved, nice RegEx case.

[someotherguy]

A little rusty with RegEx capture groups, ended up using a previous solution as a guide and documented how it works.

Spoiler

[Bennu]

Good RegEx practice!  Can't believe I actually figured them out.

Spoiler

(\d{1,2}\-[[:alpha:]]{3,10}\-\d{2,4})

([[:alpha:]]{3} \d{1,2},? ?\d{4})

There's also an interesting formula to figure out if the year  49 is 1949 or 2049... I treated it as 2049..

Spoiler

if substring(ReverseString([Date]),2,1) = '-' then

if ToNumber(ReverseString( left(ReverseString([Date]),2))) >50 then

ReverseString(
left( ReverseString([Date]),2) +'91' + Substring( ReverseString([Date]),2)
)
else
ReverseString(
left( ReverseString([Date]),2) +'02' + Substring( ReverseString([Date]),2) )
endif
else
[Date]

endif

Spoiler

[JBevan89]

my solution attached.  Great Challenge