String operations in XQuery

Question

My xml file has a line:

<asin ISBN="0001714600 9780001714601" code="aB1234Av">

I want to extract ISBN[0] i.e

0001714600 9780001714601

or ISBN[1] i.e

0001714600 9780001714601

I tried substring and tokenize but its not working to my desire. Heres my code:

<strong>{for $asin in doc('amazon.xml')/asin/@ISBN
    return (tokenize($asin/data(.),'\s'))}</strong>

(OR)

<strong>{for $asin in doc('amazon.xml')/asin/@ISBN
    return (substring($asin/data(.),1))}</strong>

How should i get that value out of it?

Do you want to conditionally output one or the other value - or do you want to output them all? Are there always two values at the most? — Jens Østergaard Petersen

Jens Østergaard Petersen Jens Østergaard Petersen · Accepted Answer · 2014-05-05T07:26:02

Using tokenize() is OK.

If you take things apart, it becomes easier to see what happens:

let $input := <asin ISBN="0001714600 9780001714601" code="aB1234Av"/>
let $isbn-string := $input/@ISBN/string()
let $isbn-items := tokenize($isbn-string, '\s')
    return
        for $isbn-item in $isbn-items
            return <strong>{$isbn-item}</strong>

You first fetch the string value of the @ISBN attribute, then tokenize it, then iterate over the tokenized items, outputting them one by one.

PS: In XPath, positional predicates start with 1, so ISBN[0] would return nothing.

String operations in XQuery

2 Answers