You should change this to
No where in your division do you truncate or round the quotient to 1 decimal place.
You are correct in noting that using val > 1.4 as a synonym for val >= 1.5 is wrong. But, there are a few issues here.
The awk greater than or equal comparison operator is >=; not =>.
When printing numbers with print or printf with the format specifier %.1f, the printing function will round the value being printed up or down to the closest number representable in that format to the value being printed. (So, the values 1.47 and 1.5491 would print as 1.5.)
The >= comparison operator compares values without regard to how that value might be rounded by various print format specifiers. (So, the comparison 1.47 >= 1.5 evaluates to false even though both values would print as 1.5 if printed using printf("%.1f\n", value).)
The double precision floating point value 1.5 happens to have an exact representation as an IEEE floating point value. The decimal values 1.3, 1.6, and 1.7, however, are not exactly representable in that format.
Hi Friends :)
I have a long file having fields in the form :
Field1 yy/mm/dd hh:mm:ss Duration(Sec)
line 1) 123123 05/11/30 12:12:56 145
line 2) 145235 05/11/30 12:15:15 30
line 3) 145264 05/11/30 13:14:56 178
.
.
I want to subtract yy/dd/dd hh:mm:ss in line (2) from yy/mm/dd hh:mm:ss in... (1 Reply)
i have a file like this .....
empno ----- ename ----- job
1 ----- scott----- manager
2----- ford----- salesman
3 ----- mark---- president
in this i wanna display second column means ename... (6 Replies)
Hi All,
I have two files in which i want to copy one coloumn from one file to another such that it appears as a separate coloumn in the other file.Please note
there already exists a coloumn in the other file.For eg
in file 1(first file) i have
12
23
35
in file 2(other file) i have
34
45... (2 Replies)
Hi all,
I have a file which contain data like 1|2009-12-12
2|2010-02-28
3|2009-02-29
i have to validate that second coloumn have proper date
i tried like
awk -F "|" ' !system("touch -d $2 file1 2> /dev/null" ) '
but its not printing any thing
but when i try using hard... (2 Replies)
I have two files with similar column pattern as given below :
2 sample lines from file1 are given below.
18 12630 . G T 49.97 . AC=2;AF=1.00;AN=2;DP=3;Dels=0.00;FS=0.000;HRun=0;HaplotypeScore=0.0000;MQ=60.00;MQ0=0;NDA=1;QD=16.66;SB=-0.01 GT:AD:DP:GQ:PL ... (2 Replies)
Hi all,
this is file1.txt
10.210.226.21 alarmSupervisionActive=true
10.64.136.209 alarmSupervisionActive=true
10.64.174.209 alarmSupervisionActive=true
10.64.182.65 alarmSupervisionActive=true
10.66.193.113 alarmSupervisionActive=true
10.80.124.67 alarmSupervisionActive=true ... (6 Replies)
I have a CSV with 6 coloumn. I need to replace a ',' with '|' in the 4th coloumn of a CSV only so i can upload in Database. When i Upload now, commas used in the text in the 4th coloumn are treated as delimiter and remaining text goes to the next coloumn. Any solutions to replace, thanks. (1 Reply)
I have several csv files, each hundreds of rows with the following layout
"","SEQ ID No. 1 Subject # 20"
"BPM neg.:",68.83
"BPM normal:",68.48
"SEQ ID No. 1 Subject # 20",79.33
"","SEQ ID No. 10 Subject # 20"
"BPM neg.:",68.05
"BPM normal:",68.58
"SEQ ID No. 10 Subject # 20",81.63... (6 Replies)
I have three files with similar pattern i need to merge all the coloumns side by side from all three files according to the first coloumn example as shown below
I mentioned 5 coloumns only in example but i have around 15 coloumns in each file.
file1:
Name,Samples,Error,95RT,90RT... (4 Replies)