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 Go to previous topicPrev TopicGo to next topicNext Topic
Postnext
Aaron BuehnerSubject: Removing quotes from text and blank lines between rows
Author: Aaron Buehner
Date: 15 Jun 2005 12:22 PM
Originally Posted: 15 Jun 2005 12:14 PM
I've been reading the O'Reilly book XSLT Cookbook and been applying some of the examples to my project. What I want to do is create a csv file from XML like this:<br> <br> <Phase><br> <PhaseCode>1550046</PhaseCode><br> <PhaseDescription>CONDUIT BAR JOIST CEILING EMT 1/2 TO 1"</PhaseDescription><br> <PhaseAbbreviation>CND BRJ EMT 1/2-1</PhaseAbbreviation><br> <PhaseSubRef>2</PhaseSubRef><br> <MaterialDollars>14277.99</MaterialDollars><br> <MaterialCount>20826</MaterialCount><br> <LaborHours>1247.53</LaborHours><br> <LaborDollars>27104.06</LaborDollars><br> <EquipmentHours>0</EquipmentHours><br> <EquipmentDollars>0</EquipmentDollars><br> <SubContractDollars>0</SubContractDollars><br> </Phase><br> <br> The problem is the quotes in the text of the PhaseDescription.<br> I want to remove the qoutes. Also the output file has blank<br> lines between the rows and I want ot get rid of them also.<br> <br> Attached is my xslt files. Untitled2.xslt imports the other


Unknowngeneric-elem-to-csv.zip
XSLT

Posttop
Ivan PedruzziSubject: Removing quotes from text and blank lines between rows
Author: Ivan Pedruzzi
Date: 16 Jun 2005 02:11 AM
Hi Aaron,

To remove quotes you can use the translate function
<xsl:value-of select="translate(., '&quot;', '')"/>

To control the empty lines try to overide the default rule for text nodes
<xsl:template match="text()"/>

Hope this helps
Ivan Pedruzzi
Stylus Studio Team

 
Topic Page 1 2 3 4 5 6 7 8 9 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.