XML returned from the server does not have 'root' element

Rennur

Version 5.3, Build 1549

Ampersand (&) causing XML returned from the server does not have 'root' element

Basically trying to insert the contents of 2 'Plain Text' attributes into a 3rd one.

Attr1: Company.Address
'Cnr Smith & Jones St'
Attr2: Company.Suburb
'Mayfair'

Attr3. Company.Google_Map
Company.Google_Map=Company.Address+", "+Company.Suburb

The function in Attr3 causes the error.
If the address in Attr1 = 'Cnr Smith and Jones St' i[/i] it works fine.

RocketRod

Yep this is the case. I tell my users not to use it in names or addresses but they do now and then. I just run a process each night to change it.

Cheers Rod

Rennur

I have created a RULE 'Do not use ampersand' to spit out an error if & is used.

If Company.Google_Map CONTAINS '&' Then
REPORT ERROR 'Address: Word (and) must be used instead of ampersand (&)'

RLJB

Could also use REPLACE_PATTERN function (check the user guide text functions section) to replace it automatically in a new field and use that for the maps

Rennur

CORRECTION

If Company.Address CONTAINS '&' Then
REPORT ERROR 'Address: Word (and) must be used instead of ampersand (&)'

Rennur

Thanks Rod

I looked through the functions but must have missed this one.

Cheers

Rennur

This rule seems to do the job. Correct me if I'm wrong 🙂

Company.Google_Map=REPLACE_PATTERN(Company.Address,'&','AND')+', '+Company.Suburb

Cheers

RocketRod

Rule great but I replace it with a blank which Google has no trouble with still finding the correct address and it replaces 1 character with 1 character. Not sure what would happen if your Company address was at its limit.

Cheers Rod