I have an XML file that has 144 columns for the last 12 year's rolling data -- and the column name: goes like this:
Column>
<Selected/>
<SourceName>09/1999 XYZValue</SourceName>
<DestinationName>Sep1999_XYZDestination</DestinationName>
<TypeName>FLOAT</TypeName>
</Column>
<Column>
<Selected/>
<SourceName>10/1999 XYZValue</SourceName>
<DestinationName>Oct1999_XYZDestination</DestinationName>
<TypeName>FLOAT</TypeName>
</Column>
......... all the way to
<Column>
<Selected/>
<SourceName>08/2011 XYZValue</SourceName>
<DestinationName>Aug2011_XYZDestination</DestinationName>
<TypeName>FLOAT</TypeName>
</Column>
We will get a new upload file every month. For processing Sep 2011 file, what I have to do is - to delete entry for 09/1999 (so that the starting month would be 10/1999) and include a new entry in the end for 09/2011. The logic should search for the appropriate string, delete that entry from XML file, and also append a new entry with the correct value. I need to use the same logic to update a TEXT file that has column names (this is the control file for loading).
If anyone can give me some idea on how this can be done in Perl, I would really appreciate it. Thanks in advance - for your help.