format file

happyv · #1 (**permalink**) 03-12-2007

Hi
I have a file called a.txt which contain a lot of data. each file used "," to identify. But the 1st, 2nd and 3rd field contain space, can I delete it and the 5th fileld is about mins, but the original format used ".", I would like to change to mm:ss (example 11.33 changed to 11:33, 0 changed to 00:00, 9.23 changed to 09:23). Can help?

11111 ,client ,customer , 2859, 11.33, 8, 21.57, 252.62
11112 ,client ,customer , 2860, 26.43, 8, 7.82, 91.62
11113 ,client ,customer , 2861, 48.27, 25, 64.55, 753.82
11113 ,client ,customer , 2862, 56.45, 18, 51.64, 603.06
11114 ,client ,customer , 2872, 8.87, 5, 8.89, 103.78
11115 ,client ,customer , 2875, .00, 1, .26, 3.00
11116 ,client ,customer , 2878, 36.22, 18, 54.94, 641.54
11117 ,client ,customer , 2881, 1.30, 2, 2.07, 24.22
11111 ,client ,customer , 2883, 12.05, 8, 16.39, 191.34
11111 ,client ,customer , 2879, .00, 0, .00, .00
11111 ,client ,customer , 2873, .00, 0, .00, .00
11111 ,client ,customer , 2871, .00, 0, .00, .00

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
To convert multi format file to a readable ascii format	gaur.deepti	UNIX for Dummies Questions & Answers	5	03-25-2008 03:03 PM
Need help to format a file	ratheesh	Shell Programming and Scripting	2	02-13-2008 06:04 PM
Convert UTF8 Format file to ANSI format	rajreddy	UNIX for Dummies Questions & Answers	9	05-25-2007 09:26 AM
Convert UTF8 Format file to ANSI format	rajreddy	UNIX for Advanced & Expert Users	1	05-24-2007 07:40 AM
man format file	trynew	Shell Programming and Scripting	3	10-07-2004 04:17 AM

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 Switch to Hybrid Mode Threaded Mode	Rate This Thread:


	Powered by