Merge two files from a common column

[Guest_imported]

I have two files...each has a phone extension column in it...how do I merge those files and print certain columns from them...??

[sig][/sig]

 

[ElgisRamon]

I guess you can use the [tt]join[/tt] command, but why don't you show us some example input? [sig][/sig]

 

[Guest_imported]

file 1
first name|last name|addr1|addr2|city|state|zip|ext

file 2
title|dept|location|ext

Match file 1 and file 2 on ext column.
Print out only first name, last name, title, dept.

I was looking for an example in awk.

Thx. [sig][/sig]

 

[bigscouse]

Assuming matching entries in each file for any particular extension: -

join -j1 8 -j2 4 -o 1.1 1.2 2.1 2.2 file1 file2

[sig]<p>Ged Jones<br><a href=mailto:gedejones@hotmail.com>gedejones@hotmail.com</a><br><a href= > </a><br>Top man[/sig]

 

[ElgisRamon]

Is that [red]|[/red] character the field separator? if so, then try [tt]join -t&quot;|&quot; -j1 8 -j2 4 ...[/tt] to tell join that's the special field sep...

I hope it works... [sig][/sig]