Shell Programming and Scripting

Hello. I have 2 files.

File 1:

1692 @00000000201@00000205@20090402@000015000
1692 @00000000202@00000206@20090402@000010000
263157760@00000000401@00000201@20090402@000056250
510584583@00000000300@00000207@20090402@000030000
571764164@00000000100@00000128@20090402@000000500
571764164@00000000202@00000147@20090402@000005000
770000464@00000000100@00000125@20090402@000005000
770000464@00000000201@00000000@ @000005000


File 2:

1692 @RONALD F. SZOPA, DMD
004408365@STRESS REDUCTION SYSTEMS
010555926@B. FAREID, DDS A PROFESSIONAL CORP.
571764164@METABOLIC IMAGING MEDICAL GROUP
033464787@DAVID YUNG NING LI
770000464@COMPREHENSIVE MEDICAL G

I tried to do a join however it isn't working. I am trying to match the first field of the first file to the first field of the 2nd file. If that condition match then produce all record from both file 1 and file 2.

Tried

awk -F\@ 'NR == FNR {i _[$1,$2]; next } ($1,$2) in _' file1 file2

doesn't work

Any help is much appreciated. Thank you.

for your example files, what's your output look like?

You can use join to find all matching lines in both files and then output the fields you want from both.

Code:

join -1 1 -2 1 -t@ -o 1.1,1.2,1.3,1.4,1.5,2.2 file1 file2

#-1 1  file1 field1
#-2 1  file2 field1
#-t@   @ delimiter
#-o format output with fields from each file where 1.*=file1 and 2.*=file2

I thought awk scanned files sequentially? not sure what you script will do.
Consider using python...

Code:

import sys
l1 = open(sys.argv[1]).readlines()
l2 = open(sys.argv[2]).readlines()
if (l1[0].split()[0] == l2[0].split()[0]):
        for x in range(len(l1)):
                print "%s,%s" % (l1[x][:-1],l2[x][:-1])

or ruby ...

Code:

l1 = open(ARGV[0]).readlines; l2 = open(ARGV[1]).readlines
if (l1[0].split[0] == l2[0].split[0])
        l1.each_with_index do |l,x| puts l.strip + "," + l2[x]; end
end

please test you code.

sorry, output would look like this:

File 1:

1692 @00000000201@00000205@20090402@000015000
1692 @00000000202@00000206@20090402@000010000
263157760@00000000401@00000201@20090402@000056250
510584583@00000000300@00000207@20090402@000030000
571764164@00000000100@00000128@20090402@000000500
571764164@00000000202@00000147@20090402@000005000
770000464@00000000100@00000125@20090402@000005000
770000464@00000000201@00000000@ @000005000


File 2:

1692 @RONALD F. SZOPA, DMD
004408365@STRESS REDUCTION SYSTEMS
010555926@B. FAREID, DDS A PROFESSIONAL CORP.
571764164@METABOLIC IMAGING MEDICAL GROUP
033464787@DAVID YUNG NING LI
770000464@COMPREHENSIVE MEDICAL G
263157760@TEST
510584583@PHOTO

Output:

1692 @00000000201@00000205@20090402@000015000@RONALD F. SZOPA, DMD

1692 @00000000202@00000206@20090402@000010000@RONALD F. SZOPA, DMD

263157760@00000000401@00000201@20090402@000056250@TEST

510584583@00000000300@00000207@20090402@000030000@PHOTO

571764164@00000000100@00000128@20090402@000000500@METABOLIC IMAGING MEDICAL GROUP

571764164@00000000202@00000147@20090402@000005000@METABOLIC IMAGING MEDICAL GROUP

770000464@00000000100@00000125@20090402@000005000@COMPREHENSIVE MEDICAL G

770000464@00000000201@00000000@ @000005000@COMPREHENSIVE MEDICAL G


I need all data from file 1 however there are a lot on File 2 that I do not need if it doesn't match file 1 field 1. Thank you for your help.

I tried that however it will only grab the first match. For example that I just gave you, it will only grab the first 2 line.

1692 @00000000201@00000205@20090402@000015000@RONALD F. SZOPA, DMD

1692 @00000000202@00000206@20090402@000010000@RONALD F. SZOPA, DMD