In one of our earlier articles on awk, we saw how easily awk can parse a file and extract data from it. Shell also has properties with which we can handle text files: files with fields separated by white spaces or CSV files in which the fields are separated by a comma delimiter. Let us see Full Article…
Viewing 1 to 2 of 2 items
Merge 2 csv files with awk
I have 2 files pipe delimted and want to merge them based on a key e.g file 1 Code: 123$aaa$yyy$zzz 345$xab$yzy$zyz 456$sss$ttt$foo 799$aaa$ggg$dee file 2 Code: 123$hhh 345$ddd 456$xxx 888$zzz so if the key is the first field, and the result should be the common key between file 1 and 2 i.e. result will be Full Article…