[PLUG] Re-formatting Date in .csv Field

[Rich Shepard]

On Tue, 25 Jan 2011, Sam Hart wrote:

> Super hackish awk that I did in five minutes, but it seems to work...
> maybe...

Sam/Fred,

   OK. You caught me. I've not used split with awk before.

> awk '{split ($1, a, ","); split (a[4], b, "/"); printf
> "%s,%s,%s,%s-%s-%s,%s,%s,%s,%s\n", a[1], a[2], a[3], b[3], b[1], b[2],
> a[5], a[6], a[7], a[8]; }'

   Thanks, both of you.

Rich