Programming Forums > Script Programming > Sed and Awk

gwilliam · May 27th, 2005, 3:32 PM

I need awk to work with two files, read a single column from file1, and taking each value, search for that value in file2.

I guess I need perhaps two forms of "while" loops, one within the other, but cannot get anything to work.

Could anyone give me a simple example to build on?

file1 is created by another process and could have 10 or 20 "codes" that I want to search for in file2 at a fixed position e.g. substr($3,5,4).

Heres hoping someone has done this....

jim mcnamara · Jun 14th, 2005, 1:31 PM

check out the comm utility first. man comm

gwilliam · Jun 17th, 2005, 10:12 AM

Thanks, but that doesn't do it for me. What I am trying to do is look through a file(file1) and for each entry in the single column found there, go through the second file locating that entry at a set column position, and if found read value in another column.
The exercise is aimed at producing an output which will be an analysis of the values found by reference to the codes.

jim mcnamara · Jun 20th, 2005, 9:12 AM

This looks for the presence of column starting at 10 ending at 14 and exists anywhere
in file2.

(Toggle Plain Text)

awk ' {print substr($3,5,4)}' file1 > t.sed
grep -f t.sed file2  > final_output

May 27th, 2005, 3:32 PM	#1
gwilliam Newbie Join Date: May 2005 Location: swansea wales uk Posts: 2 Rep Power: 0	looping in awk I need awk to work with two files, read a single column from file1, and taking each value, search for that value in file2. I guess I need perhaps two forms of "while" loops, one within the other, but cannot get anything to work. Could anyone give me a simple example to build on? file1 is created by another process and could have 10 or 20 "codes" that I want to search for in file2 at a fixed position e.g. substr($3,5,4). Heres hoping someone has done this....

Jun 20th, 2005, 9:12 AM	#4
jim mcnamara Hobbyist Programmer Join Date: Jun 2005 Location: New Mexico Posts: 228 Rep Power: 4	This looks for the presence of column starting at 10 ending at 14 and exists anywhere in file2. (Toggle Plain Text) awk ' {print substr($3,5,4)}' file1 > t.sed grep -f t.sed file2 > final_output awk ' {print substr($3,5,4)}' file1 > t.sed grep -f t.sed file2 > final_output

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Jun 14th, 2005, 1:31 PM	#2
jim mcnamara Hobbyist Programmer Join Date: Jun 2005 Location: New Mexico Posts: 228 Rep Power: 4	check out the comm utility first. man comm

Jun 17th, 2005, 10:12 AM	#3
gwilliam Newbie Join Date: May 2005 Location: swansea wales uk Posts: 2 Rep Power: 0	Thanks, but that doesn't do it for me. What I am trying to do is look through a file(file1) and for each entry in the single column found there, go through the second file locating that entry at a set column position, and if found read value in another column. The exercise is aimed at producing an output which will be an analysis of the values found by reference to the codes.

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

Programming Forums > Script Programming > Sed and Awk

looping in awk