Skip to content
Advertisement

Join Two csv file to one Csv file Based matching Column

I have 2 csv file,

first.csv

 Name  desc date

 raj   test  1-2-2015
 kumar test  2-2-205

secound.csv :

 Name   Text

 raj   Testvalue

I need to join this two csv file , if name are matching then, “Text” filed to add in first.csv file.

output.csv

 Name  desc   date     Text

  raj  Test  1-2-2015  TestValue   

Suggest me how to do this in php or linux cmd.

Advertisement

Answer

This should work.

join  <(cat first.csv) <(cat second.csv)
User contributions licensed under: CC BY-SA
2 People found this is helpful
Advertisement