Dear all,

I just started learning XQuery.
I have the following XML:

<Keywords>

  <Record Keywords="Bus"> 10 20 30 40</Record>

  <Record Keywords="Bus"> 11 21 31 41</Record>

</Keywords>

I’m using the following script to multiply by 2 values 30 and 31.  

for $v in /Keywords/Record

let $v1 := xs:float($v/tokenize(.,"[|]| ")[3])

return replace value of node $v  with replace ($v, $v/tokenize(.,"[|]| ")[3], xs:string($v1 * 2))

The output is correct (please tell me if my script is ok or if there are better ways to accomplish the same task).

<Keywords>

  <Record Keywords="Bus">10 20 60 40</Record>

  <Record Keywords="Bus">11 21 62 41</Record>

</Keywords>

Now I would like to perform a similar operation but:

case 1) applying the same operation on multiple elements (i.e. element 3 and 4)

case 2) applying the same operation on all element (i.e. 1,2,3,4)

For case 2) I tried the following (just removing the index [3])

for $v in /Keywords/Record

let $v1 := xs:float($v/tokenize(.,"[|]| "))

return replace value of node $v  with replace ($v, $v/tokenize(.,"[|]| "), xs:string($v1 * 2))

But I get the error: Item expected, sequence found: ("10", "20", "...")

I also tried to write a script with two nested for loops, but unsuccessfully.

Can you help me?