Best way to import XML Files

George Simon flowersoft at compuserve.com
Tue Jun 15 05:51:51 PDT 2004


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.


----- Original Message -----
From: "John Esak" <john at valar.com>
To: "George Simon" <flowersoft at compuserve.com>
Cc: "filePro mailing list" <filepro-list at seaslug.org>
Sent: Tuesday, June 15, 2004 12:06 AM
Subject: RE: Best way to import XML Files


>
> George,
> the command you have below will not work the way you think... you would
use
> such a command to copy all the *xml files to a directory called "big.xml".
> What you are probably trying to do is con"cat"enate all the files into one
> big file... I would do something like:
>
> for name in *.xml
> do
> cat $name >>big.xml
> done
>
> (You might want to make sure big.xml is null before each run of this
script.
> Or put that into the head of the script. It's all short enough to do from
> the command line, though.)
>
> John
>
> Visit The FP Room www.tinyurl.com/yuag7 24/7
>
>
>   -----Original Message-----
>   From: filepro-list-bounces at lists.celestial.com
> [mailto:filepro-list-bounces at lists.celestial.com]On Behalf Of George Simon
>   Sent: Monday, June 14, 2004 11:27 PM
>   To: Filepro 2 List
>   Subject: Best way to import XML Files
>
>
>   I have to import and process several XML files at a time.
>   What I'm planning to do now, since I don't know the name of the files,
is:
>   copy *.xml big.xml
>   and parse the big.xlm file.
>   Since there are no single-character field and record delimiters, what is
> the best way to import this big.xml file?
>
>   Thanks



More information about the Filepro-list mailing list