Re: Wrapping CSV format data in XML

Mike_Leditschke writes:

>> We have a need to wrapper data in CSV format in XML.

Obviously it depends on your needs (performance, etc.), but many XML 
purists would suggests that the best use of XML would be to express with 
explicit markup.

data1, data2
data3

becomes:

        <CSV>
                <LINE>
                        <ITEM>data1</ITEM>
                        <ITEM>data2</ITEM>
                        <ITEM>data3</ITEM>
                </LINE>
                <LINE>
                        <ITEM>data3</ITEM>
                </LINE>
        </CSV>

As with all XML, its verbose, but you get the benefit of XML tooling, 
stylesheets, database integration, etc.

If you really want to encode the string form, and don't have oddball 
character set requirements, you should note that the default value of the 
whitespace facet for the XML schemas string data type is preserve:  in 
that data type, carriage returns will be preserved.  (Of course, since 
you've sent to a schemas list, I'm giving you a schema-based answer.)

------------------------------------------------------------------------
Noah Mendelsohn                                    Voice: 1-617-693-4036
Lotus Development Corp.                            Fax: 1-617-693-8676
One Rogers Street
Cambridge, MA 02142
------------------------------------------------------------------------

Received on Thursday, 1 March 2001 13:50:51 UTC