alter data in column

tintin72 · #1 (**permalink**) 04-02-2009

Hello All,

I want to alter the first column of a dataset, say,

Code:

 
001 0.700 100.000
002 0.715 99.998
003 0.730 99.998
004 0.744 99.975
005 0.759 99.916
011 0.847 97.987 
012 0.861 97.317 
020 0.978 87.789
021 0.993 86.400
022 1.008 84.904
023 1.022 83.014
100 2.148 11.426
101 2.162 11.146

such that it reads

Code:

 
1.0 0.700 100.000
2.0 0.715 99.998
3.0 0.730 99.998
4.0 0.744 99.975
5.0 0.759 99.916
11.0 0.847 97.987 
12.0 0.861 97.317 
20.0 0.978 87.789
21.0 0.993 86.400
22.0 1.008 84.904
23.0 1.022 83.014
100.0 2.148 11.426
101.0 2.162 11.146

in other words, all numbers in the first column are changed from integer to floating by removing zeros if it is a first character and adding a decimal point. Can someone shown me what syntax to use?

Thanks

Franklin52 · #2 (**permalink**) 04-02-2009

Try this:

Code:

awk '{$1=sprintf("%.1f",$1)}1' file > newfile

Regards

tintin72 · #3 (**permalink**) 04-02-2009

it worked! thanks.

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
Alter string in 2nd column of line	Orbix	Shell Programming and Scripting	3	12-28-2008 05:11 AM
Need to get the first column of data	bobk544	Shell Programming and Scripting	3	08-04-2007 05:35 PM
How to write data in column	c0384	Shell Programming and Scripting	8	07-28-2007 06:18 PM
Column data reading	FarhanNaseer	Shell Programming and Scripting	1	09-19-2005 01:02 AM
glance RSS/VSS data column	xtrix	HP-UX	0	01-17-2005 10:32 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 Hybrid Mode Switch to Threaded Mode	Rate This Thread:


	Powered by