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 » problem converting CSV to XML
Conferences Close Tree View
+ Stylus Studio Feature Requests (1192)
- Stylus Studio Technical Forum (14621)
-> + DTD "ANY" isn't honored by val... (2)
-> + Replacing carriage returns wit... (3)
-> + WS with SOAP - problem with pa... (5)
-> - problem converting CSV to XML (2)
-> ->problem converting CSV to...
-> + validating xml with multiple s... (4)
-> + SOAP problems ! (2)
-> + mapping csv columns to schema (2)
-> - Access DB to XML doc using an ... (1)
-> - DataDirect SequelLink w/MS Acc... (1)
-> + Problem with DB to XML Source ... (3)
-> + problems to work from the comm... (3)
-> + Stylus Studio Enterprise WScal... (4)
-> + Erratic behaviour in EDIFACT a... (14)
-> + XML Pipeline Question (7)
-> + Stylus Studio reports invalid ... (4)
-> - Is there a way to generate a G... (1)
-> + Stylus produced XSLT not trans... (2)
-> + XML Editor spell check - bug w... (4)
-> + API unlocks OK, but fails in n... (4)
-> + EDI to XML conversion for UNOC... (11)
-> + Stylus crashed with recurence ... (2)
-- Previous [1801-1820] [1821-1840] [1841-1860] 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
edmond azaryanSubject: problem converting CSV to XML
Author: edmond azaryan
Date: 19 Jan 2007 05:00 PM
Hello,

I am fairly new to this so I apologise if this is a stupid question.

I am trying to convert a CSV file to XML format. Everything is fine except one of the coloums I have in the CSV file has multiple rows of text. I do not know what I need to check when converting to make sure that the text falls under the correct coloumn, because now only the first line falls under the correct coloumn. I have attached the file to this messege, the name of the coloumn is called "DETAILS" any suggestions would be greatly appreciated.

Thanks
Ed


Documentxmltest.csv
Posttop
Tony LavinioSubject: problem converting CSV to XML
Author: Tony Lavinio
Date: 01 Feb 2007 02:56 PM
You cannot do this with the CSV adapter, but you can with the
Convert-to-XML adapter, which can distinguish between the LF
that is used inside of the quoted string to break lines, and
the CRLF that is used to split records.
   
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.