I have a little project that I think would be possible to accomplish using python. I'm a beginner at this sort of thing, so I am posting the basic information in the hopes that someone out there could help me get started or point me in the right direction.
I have a .dbf file which contains three fields: an id (1), a Mapsheet # (455626) and finally a Mapsheet Name that corresponds to the Mapsheet# ( Big Lake ). There are +500 records in the table.
I have metadata files (179 of them) that have a corresponding Mapsheet# to the records in the .dbf table. What I want to do is read in each .xml file, search for this line:
And replace the 4555626.tif text with the matching record from the .dbf table - (Big Lake)
Is this even possible? (I assume it is) Or too difficult for a beginner?
Thanks for your help out there.