OASIS Mailing List ArchivesView the OASIS mailing list archive below
or browse/search using MarkMail.


Help: OASIS Mailing Lists Help | MarkMail Help



   XML to comma or tab separated file

[ 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. 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


News | XML in Industry | Calendar | XML Registry
Marketplace | Resources | MyXML.org | Sponsors | Privacy Statement

Copyright 2001 XML.org. This site is hosted by OASIS