Multiply whole column with a value

Shell Programming and Scripting
1

Hi,
I need to multiply 3rd column (comma seperated) of entire file by a value say 2.2.

Suppose the file is:

C,Gas $ YTD(TRI),15512.36,01/01/2010

New file should be (3rd column value multiplied by 2.2):

C,Gas $ YTD(TRI),34127.192,01/01/2010
2

Whichever suitable:

awk -F, '{$3=$3*2.2;print}' OFS=, inputFile

OR

awk -F, '{$3=$3*a;print}' a=2.2 OFS=, inputFile

OR

awk -F, '{$3=$3*a;print}' a=$var OFS=, inputFile
1 Like
3

Try

 awk 'BEGIN{FS=OFS=","}{print $1,$2,$3*2.2,$4 }' file.txt
1 Like
4 
awk -F, '{$3=sprintf("%.2f",$3*2.2)}1' OFS=, infile

or if the precision does not need to be fixed:

awk -F, '{$3*=2.2}1' OFS=, infile
1 Like
5

Should be:

awk -F, '{$3=sprintf("%.3f",$3*2.2)}1' OFS=, infile
6

.2 is only an example. The OP can choose what value he likes...