XML Editor
Sign up for a WebBoard account Sign Up Keyword Search Search More Options... Options
Chat Rooms Chat Help Help News News Log in to WebBoard Log in Not Logged in
Show tree view Topic
Topic Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 Go to previous topicPrev TopicGo to next topicNext Topic
Postnext
Holger SeligSubject: 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.

Posttop
Tony LavinioSubject: 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 Go to previous topicPrev TopicGo to next topicNext Topic
Download A Free Trial of Stylus Studio 6 XML Professional Edition Today! 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

Log In Options

Site Map | Privacy Policy | Terms of Use | Trademarks
Stylus Scoop XML Newsletter:
W3C Member
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.