File compare in UNIX


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting File compare in UNIX
# 8  
Old 10-01-2015
No, it's printing
Code:
com.acc.invm:FNS_TEST_DCCC_Mangment [94.1.6]
com.acc.invm:SendEmail [29.6.113]
com.acc.invm:SendSms [12.23.65]

# 9  
Old 10-01-2015
Code:
d2xxxx@hXXX17$ cat file1
com.acc.invm:FNS_PROD [94.0.5]
com.acc.invm:FNS_TEST_DCCC_Mangment [94.1.6]
com.acc.invm:FNS_APIPlat_BDMap [100.0.9]
com.acc.invm:SendEmail [29.6.113]
com.acc.invm:SendSms [12.23.65]

d2xxxx@hXXX17$ cat file2
com.acc.invm:FNS_PROD 94.0.5
com.acc.invm:FNS_TEST_DCCC_Mangment 94.0.6
com.acc.invm:FNS_APIPlat_BDMap 100.0.10

d2xxxx@hXXX17$ /usr/bin/nawk '
> FNR==NR         {split ($2, T, ".")
>                  VN[$1]=T[1]*10000+T[2]*100+T[3]
>                  next
>                 }
>                 {split ($2, T, "[].[]")
>                  NN=T[2]*10000+T[3]*100+T[4]
>                 }
>
> !($1 in VN) ||
>  (NN > VN[$1])
>
> ' file2 file1
com.acc.invm:SendEmail [29.6.113]
com.acc.invm:SendSms [12.23.65]


Last edited by Don Cragun; 10-01-2015 at 02:54 PM.. Reason: Fix CODE tags, again!
# 10  
Old 10-01-2015
Please use code tags as required by forum rules!

Code:
awk '
FNR==NR         {split ($2, T, ".")
                 VN[$1]=T[1]*10000+T[2]*100+T[3]
                 next
                }
                {X=$2
                 gsub ("[][]", "", X)
                 split (X, T, "[].[]")
                 NN=T[1]*10000+T[2]*100+T[3]
                }

!($1 in VN) ||
 (NN > VN[$1])

' file2 file1
com.acc.invm:FNS_TEST_DCCC_Mangment [94.1.6]
com.acc.invm:SendEmail [29.6.113]
com.acc.invm:SendSms [12.23.65]

# 11  
Old 10-01-2015
No luck this time also Smilie

Code:
/usr/bin/nawk '
> FNR==NR         {split ($2, T, ".")
>                  VN[$1]=T[1]*10000+T[2]*100+T[3]
>                  next
>                 }
>                 {X=$2
>                  gsub ("[][]", "", X)
>                  split (X, T, "[].[]")
>                  NN=T[1]*10000+T[2]*100+T[3]
>                 }
>
> !($1 in VN) ||
>  (NN > VN[$1])
>
> ' file2 file1
com.acc.invm:SendEmail [29.6.113]
com.acc.invm:SendSms [12.23.65]

---------- Post updated at 07:47 AM ---------- Previous update was at 07:30 AM ----------
# 12  
Old 10-08-2015
Why PM me?
You didnt update/post your code yet.
In neither of the two threads.

bleh, local cache issue Smilie

---------- Post updated at 18:50 ---------- Previous update was at 18:45 ----------

But anyway, why is the output different between you and RudiC?
Did you try with awk too (just for the sake of it)?

Because, using awk (me dont have nawk/solaris) get the same result as RudiC.
Login or Register to Ask a Question

Previous Thread | Next Thread

8 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Shell script (sh file) logic to compare contents of one file with another file and output to file

Shell script logic Hi I have 2 input files like with file 1 content as (file1) "BRGTEST-242" a.txt "BRGTEST-240" a.txt "BRGTEST-219" e.txt File 2 contents as fle(2) "BRGTEST-244" a.txt "BRGTEST-244" b.txt "BRGTEST-231" c.txt "BRGTEST-231" d.txt "BRGTEST-221" e.txt I want to get... (22 Replies)
Discussion started by: pottic
22 Replies

2. Shell Programming and Scripting

Compare output of UNIX command and match data to text file

I am working on an outage script and I run a command from the command line which tells me the amount of generator failures in my market. The output of this command only gives me three digits to identify the site by. I have a master list of all sites in a separate file, call it list.txt. If my... (7 Replies)
Discussion started by: jbrass
7 Replies

3. UNIX for Dummies Questions & Answers

Compare two file in UNIX

Hi, how to compare all the differences from two files in unix ? plz provide the screenshots. Thanks, Dasaradha (1 Reply)
Discussion started by: dasaradha
1 Replies

4. Homework & Coursework Questions

Compare to values in a file in unix

Here is sample file ===============Index 0=================== isActive=0, Input=1, Output=1, Status=1 State = Future , PRIMARY UnderCount=2 inCount=2 outCount=0 SCount=673 -- ===============Index 1=================== isActive=0, Input=1, Output=1, Status=1 ... (1 Reply)
Discussion started by: sooda
1 Replies

5. Shell Programming and Scripting

Compare two files in UNIX

Hi, I have two files File1 Contents: abc dcf sdc File2 Contents: dcf sdc erg Now my program should return the contents existing in File1 but not in File2. In this case output shoud be "abc" as abc is not available in File 2. It should not return "erg" by saying it is... (4 Replies)
Discussion started by: forums123456
4 Replies

6. Shell Programming and Scripting

Unix script to compare the two file

Hi, I want to compare two | delimited files.Awk is not working in my unix box.So plz give alternate solutions. Please see the below code: file1=$1 file2=$2 num_of_records_file1=`awk ' END { print NR } ' $file1` num_of_records_file2=`awk ' END { print NR } ' $file2` i=1 while do... (4 Replies)
Discussion started by: autosys_nm
4 Replies

7. Programming

compare XML/flat file with UNIX file system structure

Before i start doing something, I wanted to know whether the approach to compare XML file with UNIX file system structure. I have a pre-configured file(contains a list of paths to executables) and i need to check against the UNIX directory structure. what are the various approches should i use ? I... (6 Replies)
Discussion started by: shafi2all
6 Replies

8. UNIX for Advanced & Expert Users

Help- Unix File Compare- Struggling

I had posted this earlier about 3 weeks ago and had recieved a response and I did sort both the files and the comm command is still not working. Can someone please assist me, I would really appreciate it. Below is what I am trying to do I need to compare File A with File B and create FILE C... (2 Replies)
Discussion started by: guiguy
2 Replies
Login or Register to Ask a Question