I'm using the xmlupdater, but have encountered a problem when there is an ampersand in the path that I'm looking up. The updater doesn't find it. In the xml I'm reading in, all of the ampersands have been changed to & but if I send that as part of the string into the path part of the updater I never find a match. That's true if I use a value type of string or of xml/xquery.
How to replace an xml element with an ampersand in it
Userlevel 1
+12
- Contributor
- 218 replies
-
25 August 2016
Are you saying that the ampersand is actually in the element tag (e.g. <name&address;>)? If so, that is not valid in XML.
Userlevel 2
+17
- Contributor
- 7538 replies
-
26 August 2016
Hi @jakethepainter, XML element/attribute names cannot contain ampersands, but their values can contain ampersands as entity reference representation "&". e.g.
<?xml version="1.0"?>
<root>
<data v="a&b">c&d</data>
<data v="e&f">g&h</data>
</root>
Then, this XPath finds elements whose attribute value is equal to "a&b".
//data[@v="a&b"]Is you case similar to this?
+5
- Contributor
- 31 replies
-
29 August 2016
To todd_davis - I didn't use quotes in my description so the formatter of the discussion board changed my "&" to a regular one. Sorry for the misleading question.
Here's an example of what I've got. If I send a feature into the xmlupdater with an attribute called OLD_WMS_CODE where the value is "ASPHC&R2 G \ MH \ CU" and have an attribute called DESCRIPTION where the value is "UPDATED" and set the xmlpath to "//CU[WMS_CODE=fme:get-attribute("OLD_WMS_CODE")]/DESCRIPTION", I don't see the DESCRIPTION changing in the output xml. In the values that don't have ampersands in them, though, they update just fine.
<CU ProgID="mmDesktop.MMCompatibleUnit.1">
<DESCRIPTION>ASPHALT CUT&REPLACE; 2 FT WIDE</DESCRIPTION>
<WMS_CODE>ASPHC&R2 G \ MH \ CU</WMS_CODE>
</CU>Userlevel 2
+17
- Contributor
- 7538 replies
-
30 August 2016
Hi @jakethepainter, I was able to update the document with the following setting.
Source XML fragment (ampersands should be written with entity references)
<CU ProgID="mmDesktop.MMCompatibleUnit.1">
<DESCRIPTION>ASPHALT CUT&REPLACE 2 FT WIDE</DESCRIPTION>
<WMS_CODE>ASPHC&R2 G \ MH \ CU</WMS_CODE>
</CU>
ASPHC&R2 G \ MH \ CU
<?xml version="1.0" encoding="UTF-8"?>
<CU ProgID="mmDesktop.MMCompatibleUnit.1">
<DESCRIPTION>NEW&DESCRIPTION</DESCRIPTION>
<WMS_CODE>ASPHC&R2 G \ MH \ CU</WMS_CODE>
</CU>
Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.