[
Lists Home |
Date Index |
Thread Index
]
> We are trying to determine the best way to convert an XML
> file into a comma
> or tab separated file.
Since your data is hierarchic rather than flat, and CSV is unsuited to
hierarchic data, one wonders why you are doing this? That's not an idle
question: one can't answer your question without knowing what you are hoping
to achieve.
Some people use multiple delimiters: newline for the records, comma for the
fields, vertical bar for the subfields. Others solve the problem more
elegantly by using XML.
Michael Kay
http://www.saxonica.com/
The problem is that the XML file
> contains multiple
> instances of many elements (e.g. there is one Event Title,
> but many Event
> Sponsors) so it would be hard to do an accurate mapping from
> field labels to
> the data. E.g., from http://www.ietf.org/rfc/rfc4180.txt:
>
> field_name,field_name,field_name CRLF
> aaa,bbb,ccc CRLF
> zzz,yyy,xxx CRLF
>
> We could calculate the maximum number of each field and use
> the maximum
> number of each element we found in the field_name line. E.g.
>
> Event_title, Event_Sponsor_1, Event_Sponsor_2, Event_Sponsor_3,
> Event_Location, etc.
>
> Aaa, bbb, ccc, ddd, eee, ... (for 3 Event Sponsors)
> Aaa, bbb, , , eee, ... (for 1 Event Sponsor)
>
> However, I'm thinking that might result in an overly
> confusing file for
> simpler events.
>
> Any thoughts on this?
>
> Allison Bloodworth
> Principal Administrative Analyst
> e-Berkeley Program Office
> University of California, Berkeley
> (415) 377-8243
> abloodworth@berkeley.edu
>
>
>
>
> -----------------------------------------------------------------
> The xml-dev list is sponsored by XML.org <http://www.xml.org>, an
> initiative of OASIS <http://www.oasis-open.org>
>
> The list archives are at http://lists.xml.org/archives/xml-dev/
>
> To subscribe or unsubscribe from this list use the subscription
> manager: <http://www.oasis-open.org/mlmanage/index.php>
>
>
|
