Date Formatting

lonesoac0 · 03-05-2015, 08:44 PM

Hello all,

I am interested in re-formatting some date values from:

JAN 18-19
MAR 21-22
FEB 28-MAR 1
AUGUST 8-9

To:

JAN 18-JAN 19
MAR 21-MAR 22
FEB 28-MAR 1
AUGUST 8-AUGUST 9

Any ideas in how to do this?

syg00 · 03-05-2015, 09:18 PM

Something with a bit of logic - awk, perl, python.
Say in awk, use (white-)space and "-" as field separators, check if the third field is numeric, if so, plug the first field in before it, else use the current record as-is.

danielbmartin · 03-05-2015, 09:50 PM

With this InFile ...

Code:

JAN 18-19
MAR 21-22
FEB 28-MAR 1
AUGUST 8-9

... this awk ...

Code:

awk '{gsub("-","- ",$0)
   if (NF==3) print $1,$2$1,$3
         else print $1,$2$3,$4 }' $InFile >$OutFile

... produced this OutFile ...

Code:

JAN 18-JAN 19
MAR 21-MAR 22
FEB 28-MAR 1
AUGUST 8-AUGUST 9

Daniel B. Martin

lonesoac0 · 03-05-2015, 10:25 PM

I cannot WAIT to try it out tmw! I will let you know!