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 » Converting csv file with embedded carriage returns
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
Posttop
Thomas DorganSubject: Converting csv file with embedded carriage returns
Author: Thomas Dorgan
Date: 08 Jul 2011 08:56 AM
I get a csv file where each field is enclosed in quotes. In the note fields there are embedded carriage returns. Is there any way to get a custom converter to understand that carriage returns in a field do not constitute the end of the record? Excel understands this concept, but the xml converter tool does not. I am attaching a sample of the csv file and the xml created. Please look at this and let me know if there is a solution that I am missing.


UnknownBatchContainingPOMPN019442part.csv


UnknownBatchContainingPOMPN019442part.xml


UnknownUntitled8.conv
 
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.