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
Go to previous topicPrev TopicGo to next topicNext Topic
Postnext
neo kSubject: delimiting values of attribute and element
Author: neo k
Date: 14 Aug 2008 05:12 PM
Originally Posted: 14 Aug 2008 05:11 PM
Dear all,
I am very new to xquery.

I have a case and i am here for some help. My requirement is, value of an element or an attribute having the same xpath should be delimited using # and should be returned as a new element

ex:
<?xml version="1.0"?>
<books name="My books">
<book bookid="1" pubdate="03/01/2002">
Java Web Services
</book>
<book bookid="2" pubdate="01/01/2000">
Java Message Service
</book>
</books>

In the above case when i query using the path books/book/@bookid the response should be the values of the attribute bookid delimited using # and should look some like
<output> 1#2 </output>

similarly for elements it should look like
<output> Java Web Services # Java Message Service </output>


thanks in advance
Neo

Postnext
Minollo I.Subject: delimiting values of attribute and element
Author: Minollo I.
Date: 14 Aug 2008 05:18 PM
Something like this?
<output>{string-join(/books/book/@bookid, "#")}</output>

Posttop
neo kSubject: delimiting values of attribute and element
Author: neo k
Date: 14 Aug 2008 05:35 PM
Hi,
That works. Thanks a lot.

I feel stupid for not finding this, as i have done something very similar to this for elements and that works.

(fn:string-join(($value/text()),' | '))

The above worked nice for elements, when i tried the same for attributes it gave me a fat error. I dint want to try any more and gave a quick post :D

 
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.