schowning
asked on
XML search and replace
I have an XML document with the following dates and periods. It is run twice a month.
An example of the lines are as follows:
<DOC_REC_DT_DC Attribute="Y"><![CDATA[201 3-10-15]]> </DOC_REC_ DT_DC>
<DOC_PER_DC Attribute="Y"><![CDATA[1]] ></DOC_PER _DC>
<BFY Attribute="Y"><![CDATA[201 4]]></BFY>
There are about 10 different dates that have to be changed and each of these lines are in the document an unknown number of times. For example, doing this manually, I find the first occurrence of <DOC_REC_DT_DC... and replace all with the same text except for changing the date from 2013-10-15 to the current date.
I would like to automate this so it doesn't have to be done manually.
I don't know xml so I'd like to use a batch file or some reliable utility.
Thank you for your help.
An example of the lines are as follows:
<DOC_REC_DT_DC Attribute="Y"><![CDATA[201
<DOC_PER_DC Attribute="Y"><![CDATA[1]]
<BFY Attribute="Y"><![CDATA[201
There are about 10 different dates that have to be changed and each of these lines are in the document an unknown number of times. For example, doing this manually, I find the first occurrence of <DOC_REC_DT_DC... and replace all with the same text except for changing the date from 2013-10-15 to the current date.
I would like to automate this so it doesn't have to be done manually.
I don't know xml so I'd like to use a batch file or some reliable utility.
Thank you for your help.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.