SSDN - CSV 2 XML

XML Editor

Sign Up

Search

Options

Chat

Help

News

Log in

Not Logged in

Topic

Topic Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20

Holger Selig

Subject: CSV 2 XML
Author: Holger Selig
Date: 31 Aug 2007 03:53 AM

Hello,

I have a problem with the inbuilt csv to xml converter. The line delimiter of the csv file is crlf. Unfortunately there are also crlf's within some of the field columns. Although those are surrounded by ", Stylus Studio is not able to open the file correctly and interpretes them as a real new line. Is there a way of getting around this problem?

Thx for your help.

Tony Lavinio

Subject: CSV 2 XML
Author: Tony Lavinio
Date: 31 Aug 2007 10:51 AM

There is not a simple one.

We have an outstanding 'to-do' item which would add a switch to
disable line-ending checking while within a quoted field, but it
hasn't been scheduled for implementation yet.

Have you checked your file carefully, though? I've seen some
cases where inside the quoted string just LF is used, and it was
possible to get around it that way.

Or if the last field is always quoted, you might be able to use
quote-cr-lf as the line ending to differentiate it from the embedded
cr-lf.

Maybe a small sample of the file would help?

Topic Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20

Powered by Stylus Studio, the world's leading XML IDE for XML, XSLT, XQuery, XML Schema, DTD, XPath, WSDL, XHTML, SQL/XML, and XML Mapping!

Go to Conference:

Log In Options Username: Password:

Site Map | Privacy Policy | Terms of Use | Trademarks

Stylus Studio® and DataDirect XQuery ™are from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2016 All Rights Reserved.