Best way to import XML Files

John Esak john at valar.com
Tue Jun 15 14:19:42 PDT 2004


George
Google XML CDATA and there is a link showing you how to tell an XML parser
not to parse the text...

John




> -----Original Message-----
> From: filepro-list-bounces at lists.celestial.com
> [mailto:filepro-list-bounces at lists.celestial.com]On Behalf Of George
> Simon
> Sent: Tuesday, June 15, 2004 2:12 PM
> To: Kenneth Brody; George Simon
> Cc: filePro mailing list
> Subject: RE: Best way to import XML Files
>
>
> 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
>
> _______________________________________________
> 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