XMLEncode ( data )

XML Encode Data with HTML equivalents

Average rating: 4.2 (31 votes) Log in to vote

Andy Knasinski - Show more from this author
nrg software, llc.
http://www.nrgsoft.com

Sample input:

XMLEncode ( "Smith & Barney" )

Sample output:

Smith & Barney

Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

Substitute(
data;
["|";" "];
[" ";" "];
["&";"&amp;"];
["<";"&lt;"];
[">";"&gt;"];
["\"";"&quot;"];
["'";"&apos;"]
)

This custom function can be used to encode data passed via XML to it's HTML equivalent when for use with remote services. Note that the data itself should be encoded, not the whole XML string.

ex:
set field "XML" =
""& XMLEncode( "Smith & Barney" ) &""

Comments

		BjÃ¶rn, Sweden Mar 22, 2011
Works like a charm but there is a typo in the sample output, the function returns the correct "Smith & Barney"

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.

XMLEncode ( data )

Comments

Support this website.

Support this website.