need help sorting and combining files

scriptarg · #1 (**permalink**) 10-17-2008

I have 2 files with many lines.

File one example:
CN=VXX,CN=ug88888,OU=America,OU=State,OU=VXX,
File two example:
ul22222 Jon Smith
ug8888 Mildred Apple
I need a routine that will take the ug88888 portion of the first file and pull out the corresponding full line in file two. Then add the two together so the final output is
ug8888 Mildred Apple CN=VXX,CN=ug88888,OU=America,OU=State,OU=VXX,

Thanks,

scriptarg · #2 (**permalink**) 10-17-2008

Sorry, let me try that again.
I have 2 files with many lines.

File one example:
CN=VXX,CN=ug8888,OU=America,OU=State,OU=VXX,
File two example:
ul22222 Jon Smith
ug8888 Mildred Apple
I need a routine that will take the ug8888 portion of the first file and pull out the corresponding full line in file two. Then add the two together so the final output is
ug8888 Mildred Apple CN=VXX,CN=ug8888,OU=America,OU=State,OU=VXX,

Thanks,

shamrock · #3 (**permalink**) 10-17-2008

Code:

file1
ul22222 Jon Smith
ug88888 Mildred Apple

file2
CN=VXX,CN=ug88888,OU=America,OU=State,OU=VXX,

awk '{
   if (NR==FNR)
      x[$1] = $0
   else {
      FS=","
      split($2,a,"=")
      if (x[a[2]])
         print x[a[2]], $0
   }
}' file1 file2

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
Combining two files	hemangjani	Shell Programming and Scripting	7	06-13-2007 11:32 PM
Combining Two Files	bat711	Shell Programming and Scripting	3	10-05-2005 02:26 PM
Combining files	Enda Martin	UNIX for Dummies Questions & Answers	2	07-20-2001 11:31 AM
combining files	apalex	UNIX for Dummies Questions & Answers	3	06-19-2001 10:49 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