Date Reformat

F-1 · #1 (**permalink**) 04-24-2006

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

Ygor · #2 (**permalink**) 04-25-2006

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

F-1 · #3 (**permalink**) 04-25-2006

This solution helped. Thanks mate. Much appreciated.

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
reformat date, awk and sed	mondrar	Shell Programming and Scripting	5	06-05-2008 04:08 PM
help reformat data with awk	climbak	Shell Programming and Scripting	4	05-30-2008 03:17 PM
how to reformat a hard disk	mr_balodoy	SUN Solaris	14	08-22-2007 03:29 AM
Reformat Crontab file	alnita	Shell Programming and Scripting	1	04-11-2007 03:28 AM
reformat the file	CamTu	Shell Programming and Scripting	3	03-09-2005 05:01 PM

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode	Rate This Thread:


	Powered by