How do I remove CR/LF from address fileds in XML ?

Question

I have been troubleshooting why some CCDs are not able to parse out or be viewed in receiving system, and found in this failed document that there are CR/LF in some of the address fields. How do I remove before sending the message?

 <addr use="WP"><streetAddressLine>102 xxxxxxxxx
Street</streetAddressLine><city>xxxxxxx</city><state>WI</state><postalCode>xxxxx-
3917</postalCode><country>US</country></addr>

Answer 1

Refer to KB https://www.qvera.com/kb/index.php/1063/how-can-i-remove-carriage-returns-r-and-line-feeds-in-a-string?show=1063#q1063