UNIX for Dummies Questions & Answers

Hello,

I have a .CSV file with 10+ datetime columns. The way the data is stored
in these columns are -

4/4/2006 3:45:30 PM

I want the single digits to be left padded with a zero so the above looks like

04/04/2006 03:45:30 PM

As the dates and times are different throughout the file manually changing
it in the file with a find and replace is not considered.

Any function/command to achieve this will be appreciated. Thanks.

Rgds,
F1

This is GNU sed, and not thoroughly tested...

Code:

$ echo 'field1,4/4/2006 3:45:30 PM,f3,4,etc'>file1
$ sed -e :a -e 's!\([^0-9]\)\([0-9]\)\([/:]\)!\10\2\3!;ta' file1
field1,04/04/2006 03:45:30 PM,f3,4,etc

This solution helped. Thanks mate. Much appreciated.