XMLParse

Technical support and scripting issues

Moderators: Dorian (MJT support), JRL

Post Reply
SandyDoss
Junior Coder
Posts: 40
Joined: Wed Sep 07, 2016 12:47 am

XMLParse

Post by SandyDoss » Thu Jun 08, 2017 4:16 pm

Hi,

I have a 64 mg XML file that I need to turn into a text file delimited by...whatever.
Is XMLParse the command I need? Does XMLParse work with a file? The documentation doesn't elaborate much :cry:

Or, do I go with a VB script?

What would you suggest?

Thanks for any and all consideration - Sandy

User avatar
Marcus Tettmar
Site Admin
Posts: 7380
Joined: Thu Sep 19, 2002 3:00 pm
Location: Dorset, UK
Contact:

Re: XMLParse

Post by Marcus Tettmar » Fri Jun 09, 2017 6:38 am

XMLParse works against a variable, but you can read a file into a variable using ReadFile. However, with that size of file it could be a bit slow.

If you are converting this to a delimited text file then that implies a consistent structure. If so, perhaps you'd get more mileage using Excel to convert. See some example code to do this here:

https://www.mjtnet.com/blog/2009/10/30/ ... ml-to-csv/
Marcus Tettmar
http://mjtnet.com/blog/ | http://twitter.com/marcustettmar

Did you know we are now offering affordable monthly subscriptions for Macro Scheduler Standard?

Post Reply
Sign up to our newsletter for free automation tips, tricks & discounts