Re: Wrapping CSV format data in XML

Thanks for the reply.

Whilst the purists may wince, we've decided not to mark up the
CSV data at all at this stage, but include a tag like your <CSV>
to allow a choice in the future of fully markup up data as opposed to CSV.

Are there any limits on the size of the string? I'm looking about 1Mb of
CSV data per document, so would end up with a single string element
containing about 1Mb of text.

Regards
Michael



                                                                                                                                          
                    Noah_Mendelsohn                                                                                                       
                    @lotus.com             To:     Mike_Leditschke@nemmco.com.au                                                          
                                           cc:     xmlschema-dev@w3.org                                                                   
                    02/03/2001             Subject:     Re: Wrapping CSV format data in XML                                               
                    04:37 AM                                                                                                              
                                                                                                                                          
                                                                                                                                          




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 Sunday, 4 March 2001 06:38:48 UTC