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
Conferences Close Tree View
+ Stylus Studio Feature Requests (1171)
- Stylus Studio Technical Forum (14502)
-> + Stylus Studio with OpenJDK (2)
-> - Encoding error when importing ... (1)
-> - SEO Service in Delhi, India (1)
-> - HP Printer Support (1)
-> + Stylus Studio X16 Professional... (5)
-> + Stylus Studio X16 Enterprise -... (4)
-> - Overly complicated formatting ... (1)
-> + java apparently running, canno... (2)
-> + Stylus on Citrix - unable to v... (6)
-> + XSLT and XPath Questions (New ... (13)
-> + EDIFACT D96A CONTRL XML schema (2)
-> + JDK dropdown box empty and Jav... (2)
-> + Replacing XSD files in Report (4)
-> + Cannot locate WYSIWIG tab on X... (3)
-> + EDI X12 xml schema with segmen... (2)
-> + Error Message (4)
-> + jvm disabled message keeps pop... (2)
-> + XTSE0620: An xsl:param element... (3)
-> + Fail in installing ďApache FOP... (5)
-> - Jenkins: about the path of bui... (1)
-- [1-20] [21-40] [41-60] Next
+ Website Feedback (246)
+ XSLT Help and Discussion (7595)
+ XQuery Help and Discussion (1944)
+ Stylus Studio FAQs (159)
+ Stylus Studio Code Samples & Utilities (364)
+ Stylus Studio Announcements (113)
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?

   
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.