Compare between two files with condition Post: 303020936

Sponsored Content

Top Forums UNIX for Beginners Questions & Answers Compare between two files with condition Post 303020936 by RudiC on Tuesday 31st of July 2018 01:36:09 PM

07-31-2018

Registered User

Making the assumption you want to compare line by line, and ignoring the special case of equal values, I come up with

Code:

awk '
                {VT = $NF
                 sub (FS "*" VT "$", _)
                }
NR == FNR       {VAL[$0] = VT
                 next
                }
                {for (v in VAL) if ($0 ~ v)     if (VT < VAL[v])        print $0, VT, FILENAME
                                                else                    print v, VAL[v], ARGV[1]
                }
' file[12]
Austria Mobile 1 file1
Austria Mobile Ostr 0 file2
United Kingdom Mobile Dev 0.7 file2
United Kingdom Mobile 1 file1

EDIT: we obviously cross-posted. For equals printing the file2 info, change the < comparison to <=.

EDIT 2:

Quote:

Originally Posted by dragonfly85

. . . Grrr, it is too complicated, i know ....

Not necessarily. Once you get your ducks in a row and your spec nailed down beyond ambiguities its a matter of logics and experience.

Last edited by RudiC; 07-31-2018 at 03:01 PM..

These 2 Users Gave Thanks to RudiC For This Post:

RudiC

View Public Profile for RudiC

Find all posts by RudiC

9 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

How to compare null and space using single if condition

Hi I have a input file with many fields and each filed will be with in double quotes(""). i want to check fields contains balnk,null or space using condition using if. when i write code as below for if condition its not working a=`awk -F ',' '{gsub("\"", "", $1);'NF==0';printf $1}'...

2. Shell Programming and Scripting

How to compare 2 files & get only few columns based on a condition related to both files?

Hiiiii friends I have 2 files which contains huge data & few lines of it are as shown below File1: b.dat(which has 21 columns) SSR 1976 8 12 13 10 44.00 39.0700 70.7800 7.0 0 0.00 0 2.78 0.00 0.00 0 0.00 2.78 0 NULL ISC 1976 8 12 22 32 37.39 36.2942 70.7338...

3. Shell Programming and Scripting

Compare columns of 2 files based on condition defined in a different file

I have a control file which tells me which are the fields in the files I need to compare and based on the values I need to print the exact value if key =Y and output is Y , or if output is Y/N then I need to print only Y if it matches or N if it does not match and if output =N , then skip the feild...

4. Shell Programming and Scripting

compare 2 files and extract the data which is not present in other file with condition

I have 2 files whose data's are as follows : fileA 00 lieferungen 00 attractiop 01 done 02 forness 03 rasp 04 alwaysisng 04 funny 05 done1 fileB alwayssng dkhf fdgdfg dfgdg sdjkgkdfjg funny rasp

5. Shell Programming and Scripting

Compare the two variable with if condition

Please help me with this: I need to compare two values in if condition in shell script but its goes always to else condition: TIME_CHECK=PM TIME-CLOCK=PM if ; then echo "You have access!" else echo "ACCESS DENIED!" fi

6. Shell Programming and Scripting

How to compare 2 file with Condition.

Hello, I need to run a command or shell script that will compare 2 file with Condition. Can you please help ? thank you. File 1. ############start@linda22 ... ################## aaaaaaa bbbbbbb cccccc dddddd eeeee 11111 ############start@linda23 ... ################## aaaaaaa...

7. Shell Programming and Scripting

compare 2 files and return unique lines in each file (based on condition)

hi my problem is little complicated one. i have 2 files which appear like this file 1 abbsss:aa:22:34:as akl abc 1234 mkilll:as:ss:23:qs asc abc 0987 mlopii:cd:wq:24:as asd abc 7866 file2 lkoaa:as:24:32:sa alk abc 3245 lkmo:as:34:43:qs qsa abc 0987 kloia:ds:45:56:sa acq abc 7805 i...

8. Shell Programming and Scripting

IF condition to compare file prefix

I have files with naming as below, testS123, testS223, testB1, testC1, testD1 I need to write a if condition to print 'Hello' when the file prefix is not testS* else 'Good bye'. if then echo "Hello" else echo "Good bye" fi;

9. UNIX for Beginners Questions & Answers

Compare two files with awk and condition

I am preparing a script to check the configuration of the db2 against the standard configuration. I am fetching the output in file A and want to compare it with the standard output written in file B. File A Diagnostic error capture level (DIAGLEVEL) = 3 Audit buffer size (4KB) (AUDIT_BUF_SZ)...

LEARN ABOUT CENTOS

ip-ntable

IP-NTABLE(8)							       Linux							      IP-NTABLE(8)

NAME

       ip-ntable - neighbour table configuration

SYNOPSIS

       ip [ OPTIONS ] address  { COMMAND | help }

       ip ntable change name NAME [ dev DEV ] PARMS

       PARMS := { thresh1 VAL | thresh2 VAL | thresh3 VAL | gc_int MSEC | base_reachable MSEC | retrans MSEC | gc_stale MSEC  | delay_probe MSEC |
	       queue LEN  | app_probs VAL | ucast_probes VAL | mcast_probes VAL  | anycast_delay MSEC | proxy_delay MSEC | proxy_queue LEN  |
	       locktime MSEC }

       ip ntable show [ dev DEV ] [ name NAME ]

DESCRIPTION

       ip ntable controls the parameters for the neighbour tables.

   ip ntable show - list the ip neighbour tables
       This commands displays neighbour table parameters and statistics.

       dev DEV
	      only list the table attached to this device.

       name NAME
	      only lists the table with the given name.

   ip ntable change - modify table parameter
       This command allows modifying table parameters such as timers and queue lengths.

       name NAME
	      the name of the table to modify.

       dev DEV
	      the name of the device to modify the table values.

EXAMPLES

       ip ntable show dev eth0
	   Shows the neighbour table (IPv4 ARP and IPv6 ndisc) parameters on device eth0.

       ip ntable change name arp_cache queue 8 dev eth0
	   Changes the number of packets queued while address is being resolved from the default value (3) to 8 packets.

SEE ALSO

       ip(8)

AUTHOR

       Manpage by Stephen Hemminger

iproute2							    20 Dec 2011 						      IP-NTABLE(8)