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>
09/1999 XYZValueSep1999_XYZDestinationFLOAT10/1999 XYZValueOct1999_XYZDestinationFLOAT
......... all the way to
08/2011 XYZValueAug2011_XYZDestinationFLOAT
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.
