How to compare the current result with previous line result.?


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting How to compare the current result with previous line result.?
# 1  
Old 05-05-2015
How to compare the current result with previous line result.?

Hi Gurus,
I have requirement to compare current result with previous reuslt.
The sample case is below.
Code:
 
1   job1    1
1   job2    2
1   job3    3
2   job_a1  1
2   job_a2  2
2   job_a3  3
3   job_b1  1
3   job_b2  2

for above sample file, GID is group ID, for input line, the job run same function and get result.
for same group, I have to compare current job result the previous jobs result (just one line back).
my curernt scrip logic like below:
Code:
 
 
while loop
do 
if order=1 (group 1) then
job1_result> temp_gid1.txt
if order <>1 then
job2_result compare temp_gid1.txt and log to output file
job2_result> temp_gid1.txt
job3_result compare temp_gid1.txt and log to output file
 
if order=1 (new group) then
job1_result> temp_gid2.txt
if order <>1 then
job2_result compare temp_gid1.txt and log to output file
job2_result> temp_gid2.txt
job3_result compare temp_gid1.txt and log to output file

above logic works, but it looks very stupid. I want to put the result in ARRAY then compare the current result with ARRAR, but I am not able to figure our how to compare the current result with previous ARRAY.
another problem I have is: I don't know how to use GID to identify the group changing. so I added column ORDER to identified the new group.

Could anybody give me some help.

thanks in advance.
# 2  
Old 05-05-2015
When using a single array, you can check the current entry with the previous index.
So you fill your array, and check the current value vs the current index - 1.

Regarding the ORDER, one could use grep.
However, awk could be alot more usefull if you know how.

hth
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

How to compare previous and current item in for loop in bash?

Hey, I am trying to compare formated login and logout dates from one user at a host which I have stored in a tmp directory in order to find out the total login time. I need to compare them in order to find overlapping intervals. At first I tried to store each log in and logo date in an array... (3 Replies)
Discussion started by: Mumu123
3 Replies

2. Shell Programming and Scripting

Compare 2 file and write result

Hi friends...I have 2 files, file1.txt and reference.txt I could able to find difference using diff and following command awk 'NR == FNR { A=1; next } !A' reference.txt file1.txt above command listing data which is not in reference.txt 12.12 87 11.95 88 11.83 89 12.55 84... (12 Replies)
Discussion started by: Akshay Hegde
12 Replies

3. Shell Programming and Scripting

Compare Field in Current Line with Field in Previous

Hi Guys I have the following file Essentially, I am trying to find the right awk/sed syntax in order to produce the following 3 distinct files from the file above: Basically, I want to print the lines of the file as long as the second field of the current line is equal to the... (9 Replies)
Discussion started by: moutaye
9 Replies

4. Shell Programming and Scripting

How to compare two files to get correct result.see example?

Hello, I have two files A and B .A file consist of the words that user will put whereas file B consist of all user's LDAP a/c.I want here that if user don't mention LDAP a/c in comment than it will exit otherwise success. File A.I have a solution that I will modify the file A ...just save the... (9 Replies)
Discussion started by: anuragpgtgerman
9 Replies

5. Shell Programming and Scripting

AWK Compare previous value with current.

Hi, I have one small doubt how to go ahead and process the below requirement. File Content 1,abc,10 2,xyz,11 3,pqr,12 4,pqr,13 5,pqr,14 Output file expected: 1,mnq,1 1,ddd,2 1,qqq,3 1,sss,4 1,ddd,5 1,eee,6 1,fff,7 1,ddr,8 1,rrd,9 (3 Replies)
Discussion started by: dikesm
3 Replies

6. Shell Programming and Scripting

Compare 2 result sets using a script

select colname from syscat.columns where tabname='t' and tableschema='s' output is columnnames which are in part of primary key PK1 PK2 PK3 PK4 PK5 select colname from syscat.columns where tabname ='t1' and tableschema='s' output is columnnames which are in part of primary key for... (3 Replies)
Discussion started by: kanakaraju
3 Replies

7. Shell Programming and Scripting

compare two files, diff the result

Hi Everyone, 1.txt 00:01:01 asdf 00:33:33 1234 00:33:33 0987 00:33:33 12 00:33:33 444 2.txt vvvv|ee 444|dd33|ee dddd|ee 12|ee 3ciur|fdd the output should be: (6 Replies)
Discussion started by: jimmy_y
6 Replies

8. Shell Programming and Scripting

How to compare result lpstat with hostsfile

Hi there all, I got a long list of printers installed and a longer list of printers in my hosts file. In the hosts file I got a even longer list of printers in the hosts file I got the IP adress of all printers next to the printer name. How can I get a script working to get the printers... (0 Replies)
Discussion started by: draco
0 Replies

9. UNIX for Dummies Questions & Answers

display the result of wc -l with words before and after the result

hello showrev -p | wc -l returns: 381 What to do in case I want to have this output: number of lines returned by showrev -p is: 381 thx (3 Replies)
Discussion started by: melanie_pfefer
3 Replies

10. UNIX for Dummies Questions & Answers

While finding compare the result with given string

Hello, There are directories named by "yyyyMMdd" format. The one directory name is given and I should find & print that directory & its previous days directory names if exist. For example: 20080401 20080402 20080403 20080404 ... The given date: 20080403 The result: 20080403... (4 Replies)
Discussion started by: mr_bold
4 Replies
Login or Register to Ask a Question