Data differences


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Data differences
# 8  
Old 07-01-2010
Try this one:
Code:
awk 'NR==FNR{arr[$3]=$0; next}
$3 in arr {delete arr[$3]; next} {print}
END{for( i in arr ){print arr[i]}}
' sun5-printers.txt sun8-printers.txt > diffs.txt

# 9  
Old 07-01-2010
Thanks franklin52,

I tried, the AWK as you suggested, BUT
now its ignoring the duplicates, as per example i posted.
Code:
device for 0601jc1: lpd://172.25.53.33:515
device for 0601jc1: lpd://172.25.9.104:515

herewith is the output I am now receiving
Code:
more diffs.txt
device for 0606ge1: lpd://172.28.9.29:515
device for 5001a44: lpd://172.25.6.31:515
device for device: ///dev/null
device for 5001a55: lpd://172.25.6.31:515

Smilie
# 10  
Old 07-01-2010
Can you post some lines of the 2 input files and the expected output from the given lines?
This User Gave Thanks to Franklin52 For This Post:
# 11  
Old 07-02-2010
Here some lines from the text files:
this is the local server:
Code:
tail -20 sun5-printers.txt
device for 5001jnl: lpd://172.25.12.27:515
device for 5001pr1: lpd://172.25.6.28:515
device for 5001prg: lpd://172.25.6.27:515
device for 5001x01: lpd://172.25.12.160:515
device for 5001x02: lpd://172.25.12.160:515
device for 5601ge1: lpd://172.25.12.32:515
device for 6101a01: lpd://172.25.26.26:515
device for device: ///dev/null

this is the remote server
Code:
device for 5001hp1: socket://172.25.11.213:9100
device for 5001jnl: lpd://172.25.12.27:515
device for 5001pr1: lpd://172.25.6.28:515
device for 5001prg: lpd://172.25.6.27:515
device for 5001x01: lpd://172.25.12.160:515
device for 5001x02: lpd://172.25.12.160:515
device for 5601ge1: lpd://172.25.12.32:515
device for 6101a01: lpd://172.25.26.26:515

NOTE* printers exists on both servers, but sometimes Ip addresses may change on the remote server that have to be resynced onto the local server

Code:
more diffs.txt
device for 0606ge1: lpd://172.28.9.29:515
device for 5001a44: lpd://172.25.6.31:515
device for device: ///dev/null
device for 5001a55: lpd://172.25.6.31:515

# 12  
Old 07-02-2010
This is not the difference from given output of the local and remote server above Smilie
Code:
more diffs.txt
device for 0606ge1: lpd://172.28.9.29:515
device for 5001a44: lpd://172.25.6.31:515
device for device: ///dev/null
device for 5001a55: lpd://172.25.6.31:515

# 13  
Old 07-02-2010
Hi franklin52,
you asked for some lines from the input files??? which i posted
and after running the awk, is the differences which it gives me..is also what i posted

or am i wrong????
# 14  
Old 07-02-2010
OK, maybe I wasn't clear enough. An example:

Output 1:
Code:
device for : AA
device for : BB
device for : CC
device for : 11
device for : DD

Output 2:
Code:
device for : AA
device for : BB
device for : 22
device for : DD
device for : CC

Output Diff:
Code:
device for : 11 < -- not in Output 2
device for : 22 < -- not in Output 1

Login or Register to Ask a Question

Previous Thread | Next Thread

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

{} and ( ) differences

Can u tell the diff between the 1) $a and ${a} 2)] and ( ) 3)" " and ' ' , ` ` 4) 'a' , "a", please explain with simple example (1 Reply)
Discussion started by: mrbinoy
1 Replies

2. Shell Programming and Scripting

Differences between shells

What is the practical difference among the different shell like csh , ksh , bash etc.:confused::confused: Please use descriptive subjects instead of single words (2 Replies)
Discussion started by: hiten.r.chauhan
2 Replies

3. Shell Programming and Scripting

Differences between 2 directories

Hi, I am trying to write a script under ksh to list all the differences between two directories. For example: # ls test1 test2 I need to compare all the files under between test1 & test2. When I do diff, it only compares the diectoires but it doesn't check inside. I did do... (3 Replies)
Discussion started by: samnyc
3 Replies

4. Shell Programming and Scripting

Differences between 2 Flat Files and process the differences

Hi Hope you are having a great weeknd !! I had a question and need your expertise for this : I have 2 files File1 & File2(of same structure) which I need to compare on some columns. I need to find the values which are there in File2 but not in File 1 and put the Differences in another file... (5 Replies)
Discussion started by: newbie_8398
5 Replies

5. Shell Programming and Scripting

Printing the differences

Dear All, I am having a file with thousands of columns. I would like to find the difference between adjacent columns (ie $i and $(i+1)) and perform the following action: if the difference is less than -10, then i need to print "-2"; if the difference is between 0 and <-9, then i need to... (2 Replies)
Discussion started by: Fredrick
2 Replies

6. Shell Programming and Scripting

Help with file differences

I have two huge files in the size of 1gb. They are produced by similar processes and the expected thing is that they should match in size and contents. I have produced both the files with the processes and they seem to be off only by few bytes. Size file name 1634502037 ... (2 Replies)
Discussion started by: dsravan
2 Replies

7. UNIX for Dummies Questions & Answers

Differences

Hi all, I am using korn shell. I want to know what is the difference between hey and echo commands. (1 Reply)
Discussion started by: sivakumar.rj
1 Replies

8. Shell Programming and Scripting

Sort differences

I have a file that contains /home /opt /stand /var /usr /tmp /opt /home I need to print the lines that are unique so the output would be /stand /var /usr /tmp and omit any filesystems that are duplicates. I searched the forums but did not find anything, although i searched on... (3 Replies)
Discussion started by: insania
3 Replies

9. Solaris

Differences between Solaris 2.5 and 9

Hi Can anybody tell what are the great differences in Solaris 2.5 and 9? I am seeking information like differences in libraries, User Interface, Configuraion files, daemons, Packaging and archiving tools, Hardware supported etc. Please help me, as this is little urgent. Even if you can refer... (4 Replies)
Discussion started by: charlcy
4 Replies
Login or Register to Ask a Question