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 » XSLT Help and Discussion » new guy attempting xslt
Conferences Close Tree View
+ Stylus Studio Feature Requests (1192)
+ Stylus Studio Technical Forum (14621)
+ Website Feedback (249)
- XSLT Help and Discussion (7625)
-> - How can i attach a empty names... (1)
-> + Cannot find a matching 1-argum... (7)
-> - get value from different docum... (1)
-> + How can I change the XML heade... (2)
-> + Stylus Studio and Datapower (9)
-> + Generate XML form a XSD (2)
-> + There is no way to run xslt tr... (3)
-> + XML-Source NS is copied into t... (3)
-> - new guy attempting xslt (2)
-> ->new guy attempting xslt
-> + XML 2011 question (7)
-> + Manipulating XML with external... (2)
-> + removing duplicates from xml w... (8)
-> + Wnat to use presence of tag t... (2)
-> + modifing Andrew Welch's csv 2 ... (5)
-> + Can't use (or see) XSLT or WYS... (3)
-> + Delete the xsi:nil attribute ... (2)
-> + FOTY0012: Cannot get the typed... (20)
-> + XSLT Mapper - Two way xslt map... (2)
-> + EDI (5)
-> + XSL Test for lack of XML eleme... (4)
-- [1-20] [21-40] [41-60] Next
+ XQuery Help and Discussion (2017)
+ Stylus Studio FAQs (159)
+ Stylus Studio Code Samples & Utilities (364)
+ Stylus Studio Announcements (113)
Topic  
Postnext
sean anthonySubject: new guy attempting xslt
Author: sean anthony
Date: 03 Aug 2013 04:40 PM
Hi All,

Please bare with me im a network engineer rather than a coder, but have had to turn my hand to this for a project im working on, any chance someone could help me with what I hope will be a simple XSLT question. Given the snippet of xml shown below

[code]
<resources>
<audio>
<file>
<name>file1.mp3</name>
</file>
</audio>

<audio>
<file>
<name>file1_preview.mp3</name>
</file>
</audio>

<audio>
<file>
<name>file1_wav.wav</name>
</file>
</audio>
</resources>
[/code]
I need to find a way to select only the wav file dynamically each time and ignore the other two currently I have the following but clearly it just selects the first one.
[code]
<xsl:for-each select="resources/audio/file">

<MainFile>
<Filename>
<xsl:value-of select="name"/>
</Filename>
</MainFile>

</xsl:for-each>
[/code]
Is it possible to do something like
[code]
<xsl:if test="@name = '*.wav'">
[/code]
Really sorry but im out of my depth here and getting really frustrated as nothing I try works.

Any help would be greatly appreciated
Posttop
Ivan PedruzziSubject: new guy attempting xslt
Author: Ivan Pedruzzi
Date: 05 Aug 2013 10:47 AM

This is verbose but hopefully, more self-explanatory solution

Ivan Pedruzzi
Stylus Studio Team

XML input


<?xml version="1.0"?>
<resources>
<audio>
<file>
<name>file1.mp3</name>
</file>
</audio>

<audio>
<file>
<name>file1_preview.mp3</name>
</file>
</audio>

<audio>
<file>
<name>file1_wav.wav</name>
</file>
</audio>
</resources>


XSLT 1.0 Tranformation

<?xml version="1.0"?>
<xsl:stylesheet version="1.0"
xmlns:xsl="http://www.w3.org/1999/XSL/Transform">

<xsl:variable name="ext" select="'.wav'"/>

<xsl:template match="/">
<MainFile>
<xsl:for-each select="resources/audio/file">
<xsl:variable name="start" select="string-length(name) - string-length($ext) + 1 "/>
<xsl:variable name="file_ext" select="substring(name, $start, 4)"/>
<xsl:if test="$file_ext = $ext">
<Filename start="{$file_ext}">
<xsl:value-of select="name"/>
</Filename>
</xsl:if>
</xsl:for-each>
</MainFile>
</xsl:template>
</xsl:stylesheet>



Result


<?xml version='1.0' ?>
<MainFile>
<Filename start=".wav">file1_wav.wav</Filename>
</MainFile>
   
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.