XML Editor
Sign up for a WebBoard account Sign Up Keyword Search Search More Options... Options
search
Chat Rooms Chat Help Help News News Log in to WebBoard Log in Not Logged in
Home » Boards » Stylus Studio Developer Network » Stylus Studio Technical Forum » CSV 2 XML
Conferences Close Tree View
+ Stylus Studio Feature Requests (1192)
- Stylus Studio Technical Forum (14621)
-> + Delete rows in a MS SQL Server... (7)
-> - Attaching DB2 Database in File... (1)
-> + Can't debug xsl examples with ... (14)
-> + Best way to transform existing... (2)
-> + Exception in generated java co... (3)
-> + Java API for converting EDI X1... (2)
-> + XPath Query Editor slow perfor... (7)
-> + mapper schema problem (5)
-> + cursor issue in stylus studio ... (2)
-> + how to generate xslt code for ... (4)
-> + Web Service (12)
-> + Additional rule (2)
-> + Help needed: XMLSchema and unp... (9)
-> + Module settings for external X... (3)
-> + Finding Errors in the XML File (6)
-> - CSV 2 XML (2)
-> ->CSV 2 XML
-> + Automatic Namespace when using... (2)
-> + Can't find 'Associate XML Sche... (3)
-> + Calling Stylus Studio API from... (2)
-> + EDI TO XML using the Stylus St... (4)
-- Previous [1441-1460] [1461-1480] [1481-1500] Next
+ Website Feedback (249)
+ XSLT Help and Discussion (7625)
+ XQuery Help and Discussion (2017)
+ 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.