Apex Code Development You need to sign in to do that
Don't have an account?
NArendra Nimmana To fetch the data by considering removal of white spaces in the existing CRM data with in SOQL
My requrement is consider removal of whitespaces both in received data and existing CRM data.
I have written an API, for the recieved data i can remove the white spaces.
for eg; the received string as s1
String s1='abc cb cn';
String s2=s1.deletewhitespace();
With that recived data after removing the spaces, i have to written a soql query by considering removal of white spaces in existing data also.
how can i do that for existing data in soql.?
inside salesforce it was stored like 'abcc bcn'
i want to retrive the id of that particular record with name as above.
Thanks
Narendra.
I have written an API, for the recieved data i can remove the white spaces.
for eg; the received string as s1
String s1='abc cb cn';
String s2=s1.deletewhitespace();
With that recived data after removing the spaces, i have to written a soql query by considering removal of white spaces in existing data also.
how can i do that for existing data in soql.?
inside salesforce it was stored like 'abcc bcn'
i want to retrive the id of that particular record with name as above.
Thanks
Narendra.
May I suggest you please refer the below link for reference.
https://developer.salesforce.com/forums/?id=906F00000008x4BIAQ
Hope it will be helpful.
Please mark it as best answer if the information is informative.so that question is removed from an unanswered question and appear as a proper solution.
Thanks
Rahul Kumar