Replace Text In XML File

[Murp]

I am using Acess 2003. I have a rather large and convoluted xml file (nearly
30MB) with names in it that I would like to replace with new names.

In my Access database, I have a list of old names and new names. Is it
possible to loop through this list in Access and search for the old names in
the xml file, then replace them with the new names?

 

[Alex Dybenko]

Hi,
I think you can try to import this XML file into Access, replace values you
need using update queries on import table, and then export result table back
into XML

 

[Murp]

Thanks for your comments, Alex.

I would love to do what you suggest, but this is a Premiere Pro xml file -
too complex and and big to import into Access.

I was hoping there was a way to run a simple find/replace on the xml code
from Access. Currently I am using Macro Express loop through the values from
Access and run a find/replace in WordPad, but this can be problematic when
you have over 1600+ find/replace instances.

 

[Alex Dybenko]

Hi,
you can also open XML as a text file in access, read line by line, replace
old names to new and then save it to new file. But not sure access is best
tool for this task

 

[Brendan Reynolds]

Have you tried asking in an XML forum? It sounds as though this may be a
task for one of the XML-related technologies like x-path or x-query, but I'm
not familiar enough with those technologies to advise you. You could try
asking in microsoft.public.xml if you haven't already done so. If you're
using Microsoft's web-based interface to the newsgroups, you can find the
XML group at ...

http://support.microsoft.com/newsgr...g=en&cr=US&dg=microsoft.public.xml&sloc=en-us