UNIX for Dummies Questions & Answers

hi,
i have a file called file1.txt and it's contents are as below:

file1.txt:
-------

abc,123, thomas
dab,234,muller
gab,456,ram

The lookup file's contents are as below:

lookup.txt
----------

abc|japan
dcd|US
dab|china
gab|brazil

The output should be like:
japan,123,thomas
china,234,muller
brazil,456,ram

Note that i have different delimiter in the lookup file.
Is it possible to lookup a file having a different delimiter?

Code:

awk -F"[,\|]" 'NR==FNR{arr[$1]=$2","$3;next}arr[$1]{print $2","arr[$1]}' file1.txt looup.txt

Or the other way around:

Code:

awk -F'[|,]' 'NR==FNR{A[$1]=$2;next}A[$1]{$1=A[$1]}1' OFS=, lookup.txt file1.txt

or a bit more precise:

Code:

awk 'NR==FNR{A[$1]=$2;next}A[$1]{$1=A[$1]}1' FS=\| OFS=, lookup.txt FS=, file1.txt

thanks. it is working.