Best way to import XML Files

George Simon george at worldest.com
Tue Jun 15 11:12:27 PDT 2004


It wouldn't give me one tag at a time, it would give me a tag and then data
plus another tag, wouldn't it?
Also, the opening tag has no data after it.  Other tags may be present but
with no data in between the tags.
Confusing...
Could the record delimiter be in a variable?
Like import ascii xml=filename f=(f) r=(r)?


George Simon (IT Department)
American River Logistics, LTD
614 Progress St.
Elizabeth, NJ  07205
Phone:(908)354-7746      Fax:(908)354-7491
mailto:george at worldest.com
http://www.americanriverintl.com/



-----Original Message-----
From: filepro-list-bounces at lists.celestial.com
[mailto:filepro-list-bounces at lists.celestial.com]On Behalf Of Kenneth Brody
Sent: Tuesday, June 15, 2004 9:38 AM
To: George Simon
Cc: filePro mailing list
Subject: Re: Best way to import XML Files

George Simon wrote:
>
> Hi John, this is a Windows application so the copy *.xml big.xml wlill
merge
> all the xml files into one big one (big.xml)
> My concern was how to parse this large file when there are no record
> delimiters (each file would be one record).
> Field delimeters I'm not too concerned about because I can search for the
> XML tags.
> I could try to import the entire file into one record and then search for
> the opening and ending tags.
> Maybe Nancy has some suggestions since she does this all the time.
[...]

You could try IMPORT ASCII, with ">" as the record delimiter.  This would
at least give you one tag at a time.  You would still have to parse each
chunk, but this would break it up into managable chunks.

--
+-------------------------+--------------------+----------------------------
-+
| Kenneth J. Brody        | www.hvcomputer.com |
|
| kenbrody at spamcop.net | www.fptech.com     | #include <std_disclaimer.h>
|
+-------------------------+--------------------+----------------------------
-+


_______________________________________________
Filepro-list mailing list
Filepro-list at lists.celestial.com
http://mailman.celestial.com/mailman/listinfo/filepro-list



More information about the Filepro-list mailing list