Shell Programming and Scripting

Hi Guru,

I need 1 more help.. I promise this is gonna be the last time I bug u :P

My source file :

Code:

edited, confidential datafile

My destination file :

Code:

edited, confidential datafile

After I run your script

Code:

echo "Enter filename that you want to modify"
read destfile
nawk 'NR==FNR{a[$1]=i++;next}NF>1{print $1,(a[$1])?a[$1]:$2;next}1' FS=," " OFS=," " i=1 source.txt $destfile > tempfile
mv -f tempfile $destfile

I found out that I lost the "CST" words at the beginning (line 3 & 4) of the file as below :

Code:

edited, confidential datafile

The fields that I want the values to be changed are changed correctly though.
How do I maintain the "CST" word?

Thanks Guru.. you are so kind

Hi
Your file format keeps changing in every post

Code:

#awk 'NR==FNR{a[$1]=i++;next}NF>1{$2=(a[$1])?a[$1]:$2;}1' FS=, OFS=, i=1 a1 a2 > a2_
#mv -f a2_ a2

Guru.

Hey GURU once again you do a magic for me, that WORKS! Thank you so much!

Hahahah yeah.. now I have to remove all the files because it is work datafile, it supposed to be confidential :P