how do i compare and extract similiar data

raptrmastr · #1 (**permalink**) 06-25-2009

I have 2 files. The first file contains user names in one column. The second, and considerably longer, file contains user names in the first column and corresponding full names in the second column. Currently these are in the .xls format. I'd like to be able to compare file1 with file2 and extract the matching user names and full names to a separate 3rd file.

jim mcnamara · #2 (**permalink**) 06-26-2009

1. convert the xls to a csv - UNIX tools cannot read true xls formatted files
2. read the join man page it does just what you want

raptrmastr · #3 (**permalink**) 06-26-2009

worked like a charm. thanks!

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
Compare and extract	ford2020	Shell Programming and Scripting	8	05-15-2009 09:50 PM
extract data from a data matrix with filter criteria	ssshen	Shell Programming and Scripting	7	04-16-2009 10:38 AM
Using grep to compare files and extract the difference to another output file	spartan22	UNIX for Dummies Questions & Answers	6	02-23-2009 04:51 PM
Get data from 3 differrnt oracle DB & then compare data	Amit.Sagpariya	Shell Programming and Scripting	4	10-14-2008 07:03 AM
I need to extract last column of a file and compare the values	vukkusila	Shell Programming and Scripting	4	08-04-2007 11:21 AM

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode	Rate This Thread:


	Powered by