Wednesday, May 11, 2011

table look up using awk

awk 'FNR==NR{map[$1]=$2;next}{for (i = 1; i <= NF; i++) print map[$i];print ("\n")}' index_EWE2.txt 10Dec_ewe2_PM_cliques.txt.txt | awk '{ printf "%s ", $0 }' tmp.txt | awk '{gsub(/ /,"\n")}; 1' > 10Dec_ewe2_PM_cliques.txt

1 comment:

hamed said...

this is better.. get rid of tmp.txt



awk 'FNR==NR{map[$1]=$2;next}{for (i = 1; i <= NF; i++) print map[$i];print ("\n")}' index.txt 13Dec_group_PM_cliques.txt.txt | awk '{ printf "%s ", $0 }' | awk '{gsub(/ /,"\n")}; 1' > 13Dec_group_PM_cliques_status.txt