XQuery fn:replace not behaving as expected
Posted
by CoolGravatar
on Stack Overflow
See other posts from Stack Overflow
or by CoolGravatar
Published on 2010-05-25T01:30:19Z
Indexed on
2010/05/25
1:31 UTC
Read the original article
Hit count: 271
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, "(A[0-9]+-Replace)", $test)
Before calling replace, the variable $excel is valid XML upon output. However, when I output $excel after I call the replace function, all of the XML tags have been stripped, and $excel is a string with the content of the cells as its values. I would like to keep the XML tags there.
Any ideas?
© Stack Overflow or respective owner