Subject: Re: [xsl] CSV to XML transformation XSLT to include special characters? From: Michael Ludwig <mlu@xxxxxxxxxxxxx> Date: Thu, 03 Apr 2008 16:09:20 +0200 |
Hi Listers,
I have modified an XSLT orgignally developed by Andrew Welch to transform a CSV to an XML for importing data into a dynamic website. I am brand new to XSL and XSLT and have hit a small snag with the transform.
Maybe XSL is not the best tool for this job. I'd use a general-purpose programming language like Perl to process CSV to generate XML. Perl has modules designed to deal with practically everything, including CSV. I think this would be much easier, while at the same time taking the discussion off-topic.
Well, you could then process the resulting XML in XSL to tailor it to your needs, and that would bring the discussion back on topic. The result would look something like this:
<File> <Row> <Col>30358201</Col> <Col>Das VIERTE</Col> <Col>2008-04-06</Col> </Row> <Row> <Col>30376055</Col> <Col>n-tv</Col> <Col>2008-04-05</Col> </Row> <Row> <Col>30332822</Col> <Col>Premiere Krimi</Col> <Col>2008-04-05</Col> </Row> </File>
I've done some testing and I think it comes down to the inclusion of special characters in my CSV, which essentially breaks the transform, giving a blank result - it does not even display the error messege.
Current Thread |
---|
|
<- Previous | Index | Next -> |
---|---|---|
[xsl] CSV to XML transformation XSL, Marney Cotterill | Thread | Re: [xsl] CSV to XML transformation, Marney Cotterill |
Re: [xsl] adding hierarchy, Wendell Piez | Date | [xsl] Numbering in a hierarchy, Lech Rzedzicki |
Month |