How to use &(ampersand) to insert into table in PeopleCode
Hi,
I am reading a REST based request and a description field on the document is having '&' in it. When I am using record object Insert(), Update(), Save() etc., it is not inserting values into table. I tried to replace the & by breaking the description into parts and concatenate & instead of using it.
So if the description is 'Developer & Tester', I am breaking this and trying to use like 'Developer '|'&'|' Tester'. This is inserting the data into one table, but the rest of the message is not being parsed correctly.
If I am removing the & and replacing it with blank, then the whole message is getting parsed correctly and inserting data into all tables.