XQuery fn:replace not behaving as expected
- by CoolGravatar
I have an Excel worksheet in XML format which contains
<Cell ss:StyleID="s127"><Data ss:Type="String">A01-Replace</Data></Cell>
I want to replace @A01-Replace with a different string. I'm using the XQuery's replace function like so:
let $excel := doc("excel.xml")
let $test := "another string"
return replace($excel,…