Search Results

awk Tutorial

PS I have changed !A[$1]++ to !A[$1], there are no need to imcrement value for the second part

awk -F, 'NR==FNR{A[$1]++;print;next} !A[$1]' f2 f1 | sort

Some more easy to read...

Messed up with requirement :oawk -F, 'NR==FNR{A[$1]=$0;next}{if(A[$1]){print A[$1];delete A[$1]}else{print}}
END{for(i in A){if(A[i]){print A[i]}}}' file2 file1
Thanks for changing the code...

awk -F"," 'NR==FNR{a[$1]=$0;next}
{print $0;delete a[$1]}
END {for (i in a){print a[i]}}' File1 file2 | sort

Try this:
awk -F, '
NR == FNR {
A[$1] = $0
next
}
{
B[$1] = $0
}
A[$1] {
$0 = A[$1]
...

No, that's not what I meant. What I described in my first post is all you need to do. There is no need to store the file in an array.

Throw away what you've got. Then, simply set the separator,...