Please use code tags as per forum rules for commands/Inputs/codes which you use in your posts.
Could you please try following and let me know if this helps you.
Output will be as follows.
I have not tested it with many scenarios, as per your Input_file I have tested, if you have more conditions and terms please mention them with sample Input_file and expected output into code tags and let me know on same. EDIT: Also one more thing I wanted to know in case there are records where site ids are NOT same but they are fulfilling the other cases what should we do then? As my code above will not take care of it.
So if you want to remove this kind of condition then please do let us know with more details on your requirement. As there can be lots of permutations and combinations could be make out of this, so clear requirement is must here. EDIT2: Adding a non-one liner form of solution now for same.
Thanks,
R. Singh
Last edited by RavinderSingh13; 04-16-2016 at 10:45 AM..
Reason: Added onre more condition of count of site id as per user's requirement. EDIT2: Added a note for user now. added a non-one li
This User Gave Thanks to RavinderSingh13 For This Post:
Hi,
I've encountered a problem with a perl and ksh script that totals a certain field in a text file. The computed total of the script is 295540304 but the expected is 297959288, a 2 million difference. The KSH script reads from bottom to top, and the discrepancy started on line 47 (1279th MAN... (1 Reply)
Hi,
I am trying to get the cpu usage of a job/process. The machine that has these jobs is a cluster with 1 master node and 10 compute nodes.
Now, the complexity is that not all jobs are on the master node. So, in order to get the cpu usage of a job at another node, I have to ssh into it and... (0 Replies)
Hi All,
i have an input below.
As long as "x= 1" , i would want to capture 2 lines using sed or awk
for eg :
0001 x= 1 $---------------------------------..-.--..
0001 tt= 137 171 423 1682 2826 0
Pls help. Thanks in advance.
Note that the number of lines in each block do... (37 Replies)
Guys, have any idea for the script like this? also to compute w/ decimal.
thanks
a=10
b=20
c=30
d=40
if a < b then ( a -b)*1024 = free space
b + (c -d) = total space
if a > b then (b / d)*1024 = cpu (3 Replies)
Hi,
I use this script to compute compilation time several time to get system performance and compare different system:
#!/bin/sh
# measure the different between time before and
# after the compilation of benchmark
# Start at iteration 1
num=1
while
do
# Add one to the iteration... (3 Replies)
I have a project to migrate my club's membership database from Access to web based using MySQL/PHP, but I have a problem I can't get my head around and would appreciate some help...
Background...
I want to be able to display each member's data on screen and add a Previous and Next button to move... (2 Replies)
Hi Friends,
My input file is like this
chr1 100 200
chr1 300 330
chr1 2000 2000
chr1 5000 5000
chr2 7790 7890
chr2 8000 8000
If the difference of third and second columns is zero, then subtract 500 from second column and add 500 to the third column.
So, my output would be
chr1... (1 Reply)
Hi,
I want to calculate diff b/w these starttime and endtime with use of mktime. I need response time in milisecond. I am using mktime to get these times. last three digits are in milisecond
Starttime 2013-04-03 08:54:19,989
End time 2013-04-03 08:54:39,389 (9 Replies)
Hello,
sorry if this is an easy thing, but I tried to make it run the whole morning, but it doesn't work so far...
I am logged in on a visualization node of a high performance cluster. On this node I can run several gui-based software for the postprocessing of my cfd-data.
As the... (1 Reply)