Shell Programming and Scripting

Hi All,

I need an enlightenment.
I have a file that some field need to be replaced.
sample : fileA.txt

abc,4#cik#221,text
abc,4#kus#343,text
...
...

what I need to replace is the "cik" and "kus" field to their fix value.
I have another file : fileB.txt that has value of "cik and "kus",
such as
cik,001
kus,002
...
...

so the result will be like this :

abc,4#001#221,text
abc,4#002#343,text
...
...

I can do manually it with awk
awk '/cik/{gsub(/cik/, "001)};{print}'

but, it's trouble some because of the large data.
do anyone have an idea so I can do it in 1 script ?
Thank you.

Try this:

Code:

awk 'NR==FNR{a[$1]=$2;next}a[$2]{$2=a[$2]}1' FS="," fileB.txt FS="#" OFS="#" fileA.txt

Use nawk or /usr/xpg4/bin/awk on Solaris if you get errors.

Regards