Re: Process two files simultaneously

Ed Morton wrote:
> 
> On 2/7/2008 1:45 AM, Combatwombat wrote:
>> Thanks for your reply, Ed!
> 
> You're welcome, but in future please leave enough context so your post
stands
> alone as this is netnews not a web forum.
> 
>> The old.csv has numerous lines like this:
>>
>> AAA80008	Automobile fins		AAA	CS	0
>>
>>
>> the replacement csv has lines like this:
>> AAA 	Archies Automobiles and Airplanes
>>
>>
>> so by replacing the AAA in the record of old.csv we end up with:
>>
>>
>> AAA80008	Automobile fins		Archies Automobiles and Airplanes	CS	0
>>
>> Thanks!
> 
> If those are tabs between the fields then all you need is:
> 
> awk 'BEGIN{FS=OFS="\t"} NR==FNR{a[$1]=$2;next} {$3=a[$3];print}'
replacement.csv
> old.csv
> 
> 	Ed.
> 

Thanks, Mate! that did it;
awk 'BEGIN{FS=OFS=":"} NR==FNR{a[$1]=$2;next} {$4=a[$4];print}' 
replacement.csv old.csv > result.csv

(there was another tab in there, and the csv is colon delimited)
You the man, I've spent hours ba****ng my head on this one, and was just 
about to go and learn python to do it.