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 10 11 12 13 14 15 16 17 18 19 20 Go to previous topicPrev TopicGo to next topicNext Topic
Postnext
Daniel LuczakSubject: Changing data as it goes into XML file
Author: Daniel Luczak
Date: 01 Oct 2008 02:27 PM
Hellow support
I have an XSLT file where I map a CSV file to XSD and export out a XML.
My question is the CSV file has field with 1 character alway in the beginning followed by text example is C232323456 I only need the 232323456 in the XML file-- Is there a way to have the XSLT file delete the first character.

Thanks

Postnext
Minollo I.Subject: Changing data as it goes into XML file
Author: Minollo I.
Date: 01 Oct 2008 02:48 PM
<xsl:value-of select="substring('C123', 2, string-length('C123')-1)"/>

...replacing the literal "C123" with the correct XPath expression to identify your value.

Postnext
Daniel LuczakSubject: Changing data as it goes into XML file
Author: Daniel Luczak
Date: 01 Oct 2008 04:23 PM
I tried this but I do not get the data from the .csv file but the field name called NRID_NUMBER__C with the value of RID_NUMBER__C in the NRID placeholder in the XML file. NRID is in the XSD file and NRID_NUMBER__C' in in the .csv file

My entry is

<xsl:attribute name="NRID">
<xsl:value-of select="substring('NRID_NUMBER__C',2,string-length('NRID_NUMBER__C')-1)"/>
</xsl:attribute>

Postnext
Minollo I.Subject: Changing data as it goes into XML file
Author: Minollo I.
Date: 01 Oct 2008 04:30 PM
Removing the single quotes will help:

<xsl:attribute name="NRID">
<xsl:value-of select="substring(NRID_NUMBER__C,2,string-length(NRID_NUMBER__C)-1)"/>
</xsl:attribute>

Posttop
Daniel LuczakSubject: Changing data as it goes into XML file
Author: Daniel Luczak
Date: 01 Oct 2008 04:35 PM
This worked
Thanks

 
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.