Shell Programming and Scripting

Hi I am very new to shell scripting (and linux in general)...

I am trying to build some script, that will read a person from a csv file, (each person will have an ID, eg id001abc, which will go up one by one a few hundred times) then when find and replace the matching data in an xml file.

The csv has two collumns the person id and a location. the ID in the xml file is wrong so needs to be updated to what the csv says, but will have the same term in the ID at one point, so it could be xyzid001xyz. Both files have the correct location.

I have no idea how to start this off so any help would be greatly appreciated.

Sam

Best post a snippet of both files using code tags. You can mark the mentioned strings inside bold for example.

So the CSV file will look as follows:

Code:

dorset, id001abc
bristol, abcid002xyz
london, id003abc
london, id004abc
southampton, id005cde

while the xml will look like:

Code:

<RecordHeader> 
   <id>xyzid001xyz</id>
   <location>dorset</location>
   <age>21</age>
</RecordHeader>
<RecordHeader> 
<id>xyzid002abc</id>
<location>bristol</location>
<age>51</age>
</RecordHeader>

Thanks

How are you going to match up records between the two files? Are they in the same order (with no missing records)?

The csv file will be in order, so i was hoping on doing a find and replace, but have no clue about how to do it. I was thinking that the script would look at the first line of the csv, take the id, search the xml for the term, and replace. The strings will be different, so the only constant will be id001 for example, with both strings having different values either side. Then move onto the next line of the csv.

Hopefully i have explained that right, complicated i know but i just dont have a clue haha