Challenge #316: Blowing in the Wind - Part 1

[Erin]

I always try to avoid RegEx - but can't - and then have to spend time figuring it out. 😐

[AGilbert]

Love some regex practice.

[lwolfie]

Great parsing exercise

[Bobbyt23]

Lovely bit of Regex to sort the data. Ooof.

[aiahwieder]

The answer, my friend . . .

[cmoussa]

[robert-headington]

#316

[Suresh_batchu]

Solved !!

[3I_ATLAS]

The hardest parts are the RegEx:

Spoiler

(.*)\s+(\d+) MPH\s{3,10}(.*)\s{3,10}(.*)

followed by the parsing of the time:

Spoiler

if contains ([TimeDate],'AM') then
if tonumber(left([TimeDate],2))= 12 then
"00"+":"+Substring([TimeDate],2,2)+":00"
else
left([TimeDate],2)+":"+Substring([TimeDate],2,2)+":00"
endif
else
if tonumber(left([TimeDate],2))= 12 then
left([TimeDate],2)+":"+Substring([TimeDate],2,2)+":00"
else
tostring(12+ tonumber(left([TimeDate],2)))+":"+Substring([TimeDate],2,2)+":00"
endif
endif

Final solution:

Spoiler