You need to sign in to do that
Don't have an account?
![karthik karthik karthik karthik](https://dfc-org-production.my.site.com/img/userprofile/default_profile_45_v2.png)
How to Replace null value fields with empty string and return all fetched fields
Hi All,
Using SOQl I have fetched 4 fields all the fields are Text datatypes, if any fields have null value i want to replace null value with empty string and return all 4 fields. Please i need urgent help can anyone send some sample code.
Thanks in advance.
Using SOQl I have fetched 4 fields all the fields are Text datatypes, if any fields have null value i want to replace null value with empty string and return all 4 fields. Please i need urgent help can anyone send some sample code.
Thanks in advance.
if(CHECK Euals to NULL){ ASSIGN blank value} else if(CHECK Equals to BLANK OR '0'){ Assign blank value}
Thanks,
Arun
All Answers
Please see the below code
Please let me know if the helps.
As a common practice, if your question is answered, please choose 1 best answer.
Additionaly you can give every answer a thumb up if that answer is helpful to you.
Thanks,
Arun
Thanks for your response, Currently i'm working on integration here i have a single record at a time. In that record have multiple fields and multiple datatypes. How to put empty data string or null based on datatypes, ex: i have 10 fields in my query all are different datatypes how could i find if i get string or integer or some other datatype. Please i need help.
Thank you.
the data you are getting is from SALESFORCE or 3rd party?
if(CHECK Euals to NULL){ ASSIGN blank value} else if(CHECK Equals to BLANK OR '0'){ Assign blank value}
Thanks,
Arun