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?