Technical support and scripting issues
Moderators: JRL, Dorian (MJT support)
-
SandyDoss
- Junior Coder
- Posts: 40
- Joined: Wed Sep 07, 2016 12:47 am
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
Or, do I go with a VB script?
What would you suggest?
Thanks for any and all consideration - Sandy
-
Marcus Tettmar
- Site Admin
- Posts: 7395
- Joined: Thu Sep 19, 2002 3:00 pm
- Location: Dorset, UK
-
Contact:
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/