I have two sample files like this:$ cat file1abc,sachincat,kumar $ cat file2xyzpressure$ cat file3 xyz,sachinpressure, kumar I want the first column of file1 to be replaced with file2.I tried doing something like this:$ awk 'FNR==NR{a[NR]=$3;next}{$2=a[FNR]}1' file1 file2I'm using Solaris 10 and it didn't appear to support this. Any other suggestions?
replace column of a csv file with column from another file
shell script;sed;awk;perl;csv