i want replace a string in one file with str

Microsoft Windows powershell scripting g...
August 19, 2010 at 01:06:29
Specs: Windows XP, n/a
Hi friends

I already posted my problem with my script(thanks to nails for his repose) but some how awk script making the things complicated..
so i'm seeking a much effective code.let me explain my scenario

i'm having a csv file with some columns with column names
Datafile.csv contains so many records like below

Lastname FirstName Suffix Speciality Status Title Expirydate City State Zip
Gefffry John JR Pediatrics Active MD 09/12/2011
Dean Loobro SR Numerology Active MD 09/12/2011
carlos Moya HIV/AIDS Active MD 09/12/2011

and there is another Spec.csv file like

speciality code
Pedaitrics 250US
HIV/AIDS 11HAS
Cardilogy 22CR
Painmangement 17PM


i want to replace the Speciality value in Datafile.csv with the code in Spec.csv and the unknown specialities in this case
Numerology shud be placed in a seperate file...

please help me writng the code using unix


See More: i want replace a string in one file with str

Report •

#1
August 19, 2010 at 07:42:01
I answered this question in the other thread. You should be able to easily modify it.

But I thought I would point out that the Suffix in your data file appears to be optional. awk will not like this. This is a problem you have to fix.


Report •
Related Solutions


Ask Question