I have 2 csv file,
first.csv
JavaScript
x
Name desc date
raj test 1-2-2015
kumar test 2-2-205
secound.csv :
JavaScript
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
JavaScript
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.
JavaScript
join <(cat first.csv) <(cat second.csv)