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

Filed under:
|

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

Related posts about excel

Related posts about xquery