Text field with "&" gets changed to "and" on record creation

[jaydee]

I'm using an FaaS donation form that passes designations to Salesforce. When the field with value "John & Mary" is passed to Salesforce, it is written as "John and Mary". I am using Process Builder and Flows to use this field to create GAU Allocations. The field lookup fails due to the & being changed to and. All works fine as long as the field being mapped doesn't contain "&".

Help!

[jaydee]

Access has been granted for a week to OrgID 00D37000000Q0B6

[CnP.Support]

Good day @Jaydee,

The "&" sign cannot be handled by Salesforce since it does not support CDATA in XML. Because of this limitation we replace the "&" sign with "and". Currently there is no workaround for this as we are limited by what we can do in Salesforce.

Hope that answers your question.

[jaydee]

Can I count on it that when an "&" is passed that it will ALWAYS be changed to "and"? Were you doing some testing in the Org earlier today? I received error emails that I don't know how else they could have been generated.

Thank you

[CnP.Support]

Good day @jaydee,

The "&" sign is always replaced with "and" as Salesforce does not support the symbol in the XML.

Please let us know if we can be of more assistance.