Float number format problem -Awk

Shell Programming and Scripting
1

Here is the script I'm using

awk '{print $1,"\t",(($2+$3)/2)-x,"\t",(($2+$3)/2)+x,"\t",$4,"\t",$5}' x=500 $1

I just want to make float numbers (red) like normal numbers (green)
output

cX     1.65107e+08     1.65108e+08     13      64.2
cX     165112764       165113764       27      96.7
cX     165142764       165143764       14      53.73
cX     1.65325e+08     1.65326e+08     180     55.96

Help would be appreciated
Thanx

2

Use printf:

e.g.

$ awk -F ":" '{sum+=$NF} END {print sum}' data.txt
1.27084e+10

$ awk -F ":" '{sum+=$NF} END { printf ("%0.0f\n", sum)} ' data.txt
12708429091

$ awk -F ":" '{sum+=$NF} END { printf ("%d\n", sum)} ' data.txt
12708429091
3 
awk -F '{printf ("%0.0f\n",$1,"\t",(($2+$3)/2)-500,"\t",(($2+$3)/2)+500,"\t",$4,"\t",$5)}' x=500 $1
4

Hi, could you please provide few of sample lines from your input file.

5 
cX    165112562       165113966       27      96.7
cX    165142877       165143651       14      53.73
cX    165323227       165327550       180     55.96
6 
$ awk '{print $1,"\t",(($2+$3)/2)-x,"\t",(($2+$3)/2)+x,"\t",$4,"\t",$5}' x=500 file.txt 
cX 	 165112764 	 165113764 	 27 	 96.7
cX 	 165142764 	 165143764 	 14 	 53.73
cX 	 1.65325e+08 	 1.65326e+08 	 180 	 55.96

$ awk '{printf ("%s\t%0.0f\t%0.0f\t%0.0f\t%0.2f\n", $1, (($2+$3)/2)-500, (($2+$3)/2)+500, $4, $5)}' file.txt 

cX	165112764	165113764	27	96.70
cX	165142764	165143764	14	53.73
cX	165324888	165325888	180	55.96
7

working fine. but so many symbols ha!

Thanx
Ruby

8 
awk '{print $1,(($2+$3)/2)-x,(($2+$3)/2)+x,$4,$5}' x=500 OFS='\t' OFMT='%.f' file.txt