Column matching

byran cheung · 03-31-2015, 10:10 PM

I have two file , the format as below .

file A
======

Code:

Name   Education Level	Sex
====   ===============  ===	
Mary   Unviersity	F
Peter  Unviersity	M
John   Unviersity	M
Eva    High School	F
Bill   Post Graduate	M
Eddie  Post Graduate 	M

file B
=======

Code:

Education Level Type 
=============== ====
Unviersity	 A
High School	 B
Post Graduate	 C

I would like to do the matching , add the third column to the matched file , the matching result would be as below file , would advise how to do it ? thanks

Output file after match
========================

Code:

Name   Education Level	Type	Sex	
====   ===============  ====    ===	
Mary   Unviersity	A	F	
Peter  Unviersity	A	M
John   Unviersity	A	M
Eva    High School	B	F
Bill   Post Graduate	C	M
Eddie  Post Graduate 	C	M

grail · 04-01-2015, 01:11 AM

Sounds like a plan, where is your attempt and where are you stuck? I have seen similar examples on this site, so you may be able to search for a solution.

lucmove · 04-01-2015, 01:30 AM

If I were you, I would be just as lazy as I am and do this:

1) Edit the header on file A manually.

2) Write this script:

script.sed

Code:

s/Unviersity/University\tA/
s/High School/High School\tB/
s/Post Graduate/Post Graduate\tC/

3) Then run:

Code:

sed -f script.sed fileA.txt > result.txt

Not clever, but does the job. You just may have to run the resulting file through a formatting tool, to fix the size of each column.

Note that I fixed the misspelling on 'University' for you.

AnanthaP · 04-01-2015, 04:22 AM

Using awk and reading in fileB followed by fileA ...

If NR==FNR (ie fileB) then read the values into an associative array.

Else (ie fileA) for each record, seek the result in the associative array and write the output.

OK