calculations in awk/sed

anchal_khare · #1 (**permalink**) 03-25-2009

Hi friends,

I am in a little confusion.
I have a comma separated file contains hugh records.
say,

Code:

88562848,21-JAN-08,2741079, -1188,-7433,TESTING
88558314,21-JAN-08,2741189, -1273,-7976,TESTING

pludi · #2 (**permalink**) 03-25-2009

Code:

$ cat csv.txt
88562848,21-JAN-08,2741079, -1188,-7433,TESTING
88558314,21-JAN-08,2741189, -1273,-7976,TESTING
$ awk -F, '{$4*=100;$5*=100;print $1","$2","$3","$4","$5","$6}' csv.txt
88562848,21-JAN-08,2741079,-118800,-743300,TESTING
88558314,21-JAN-08,2741189,-127300,-797600,TESTING
$

anchal_khare · #3 (**permalink**) 03-25-2009

Hi Pludi,

Thanks for the solution.
Its working.

-Anchal

summer_cherry · #4 (**permalink**) 03-26-2009

Code:

awk -F"," '{$4*=100;$5*=100;print}' filename

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
Date Calculations	mitschcg	UNIX for Dummies Questions & Answers	8	03-06-2009 04:40 AM
ksh, calculations using bc	cesarNZ	Shell Programming and Scripting	2	12-14-2008 10:42 PM
how do you get input of a file to calculations	nadman123	Shell Programming and Scripting	6	04-11-2008 04:14 AM
Time Calculations	Nysif Steve	UNIX for Dummies Questions & Answers	5	09-14-2007 09:49 AM
Float calculations	sharmavr	UNIX for Dummies Questions & Answers	1	07-26-2006 03:18 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