Xml special characters and xlate

[Richard Kreiss]

Is there a way to xlate to replace a single character with a string?

Example:

Need to replace the & in H & R block with &

Name="H & R Block"

When I test xlate(name,"&","&") the result is the first letter of &
and not the whole string.

Any way to easily do this?  I need to also replace ' on O'Conner.

I can trap these special characters using name co "&" or name co "'"

But for xml output this must be H & R Block" or James O &aposConner.

Now I could, once trapped, loop through the field until I find the character
and then use a mid statement  to replace the value.

However, there must be an easier way short of changing the values in the
file containing the name.

Richard Kreiss
GCC Consulting