comparing csv files

Posted by Surresh2121 on Stack Overflow See other posts from Stack Overflow or by Surresh2121
Published on 2010-01-22T01:24:53Z Indexed on 2010/03/26 8:03 UTC
Read the original article Hit count: 408

Filed under:
|
|
|

I want to write a shell script to compare two .csv files. First one contains filename,path the second .csv file contains filename,paht,target. Now, I want to compare the two .csv files and output the target name where the file from the first .csv exists in the second .csv file.

Ex.

a.csv

build.xml,/home/build/NUOP/project1  
eesX.java,/home/build/adm/acl

b.csv

build.xml,/home/build/NUOP/project1,M1
eesX.java,/home/build/adm/acl,M2
ddexse3.htm,/home/class/adm/33eFg

I want the output to be something like this.

M1 and M2

Please help Thanks,

© Stack Overflow or respective owner

Related posts about csv

Related posts about compare