Search Results

yes this works , appends properly

awk -F, 'FNR==NR{a[$1]=$7;next} {print (($1 in a) ? $0","a[$1] : $0",NA");}' file2 file1 > tmp && mv tmp file1

thanks all

[root@oc6120651657 shyam]# awk...

ok

file1.txt
XX,ZZ,XC,EE,RR,BB
XC,CF,FG,RG,GH,GH

File2.txt

DF,GH,MH,FR,FG,GH,NOTOK
XX,NM,XC,EE,RT,BB,OK

Result

Day1

XX,ZZ,XC,EE,RR,BB,OK -- > since xx in both file1,file2...

okay first command works

if i want to add NA

XX,ZZ,XC,EE,RR,BB,OK
XC,CF,FG,RG,GH,GH,NA

file1 is base template , is that possible to print NA if the first column is not found in file2 as...

yes below is idea grep the first column in file1 and compare with
first column in file2 and awk the 7 th column value and print result

for n in `cat /tmp/file1.txt |awk -F "," '{print $1}'`...

Hi

i have 2 files

file1.txt

XX,ZZ,XC,EE,RR,BB
XC,CF,FG,RG,GH,GH

File2.txt
DF,GH,MH,FR,FG,GH,NOTOK
XX,ZZ,XC,EE,RR,BB,OK


result

XX,ZZ,XC,EE,RR,BB OK

look for column1 ,...