Script to compare numbers inside two text files

bugg_deccan · 10-17-2007, 05:53 AM

Hai all,

I have two txt files.
I want to read a number(s) in a file and check for same number(s) in another file.
If match is found then write out the mathched number(s) to another new file

eg:
test1.txt
10,12,1984,45678952

test2.txt
09,12,1984,45789632
10,12,1984,45869874

I want to read the first three comma separated vales from test1.txt(10,12,1984) and check it in test2.txt. In this case one match is found. So I need the O/p file to be as

10,12,1984,45678952,45869874

Can any one help me please....

radoulov · 10-17-2007, 06:41 AM

Code:

awk 'NR==FNR{p=$1$2$3;r=$0;next}
$1$2$3==p&&$0=r","$NF' FS="," test1.txt test2.txt

ghostdog74 · 10-17-2007, 01:37 PM

Code:

awk 'BEGIN{OFS=FS=","}
 FNR==NR{ u=$1","$2","$3;x[u]=$NF;next }
 {
  k=$1","$2","$3
  print k,x[k]
 }
' "file2" "file"

angrybanana · 10-17-2007, 10:53 PM

Quote:

Originally Posted by bugg_deccan

I want to read a number(s) in a file and check for same number(s) in another file.

Not sure if you have multiple lines in the first file or not. If you do, here's a small python solution for it.

Code:

import sys

file1 = dict(line.strip().split(',',1) for line in open(sys.argv[1]))
file2 = dict(line.strip().split(',',1) for line in open(sys.argv[2]))

for x in set(file1) & set(file2):
        print ','.join([x, file1[x], file2[x]])

Usage:
python compare.py test1.txt test2.txt

This will work if you have multiple lines in both files and you need to compare them all.

This program makes two assumptions (cause I'm lazy):
1. The files aren't some sort of huge files that will fill up all your ram. (stores files in memory)
2. There are 4 numbers on each line, not more.

Both are easy fixes, so if you need them just ask.