I have a file called testfile as per my requirement I want to subtract coloumn3 with coloumn 4 & divide it with (1024*1024*1024)) and finally if the value is greater than 1.5 then it should be printed
formula looks like this (($3-$4)/(1024*1024*1024))
---------- Post updated at 08:17 AM ---------- Previous update was at 06:50 AM ----------
this is new code , but not getting expected results
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)