Could you tell me how to convert the following dates?
If I have m/d/yyyy, I want to have
0m/0d/yyyy. I want my dates to always be 8 digits.
In other words, I want a 0 inserted whenever the month or day is a single digit.
My issue is first I need to use FS="," to get field $4 for the date portion,
within that I need to redefind FS="/" to evaluate the mm and dd portions.
Thanks,
brunc
ex. data
,,,12/6/2012,Harry H,Add,Add,Sys_RTH,111.222.333.777
,,,2/6/2012,Carry H,Add,Add,Sys_RTH,111.222.333.777
desired result.
,,,12/06/2012,Harry H,Add,Add,Sys_RTH,111.222.333.777
,,,02/06/2012,Carry H,Add,Add,Sys_RTH,111.222.333.777