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
Or, do I go with a VB script?
What would you suggest?
Thanks for any and all consideration - Sandy
XMLParse
Moderators: Dorian (MJT support), JRL
- Marcus Tettmar
- Site Admin
- Posts: 7395
- Joined: Thu Sep 19, 2002 3:00 pm
- Location: Dorset, UK
- Contact:
Re: XMLParse
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/
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?
http://mjtnet.com/blog/ | http://twitter.com/marcustettmar
Did you know we are now offering affordable monthly subscriptions for Macro Scheduler Standard?