Apex Code Development You need to sign in to do that
Don't have an account?
kirubakaran viswanathan How to retrieve data from TEXT field which has values in table?
I have a text field, which has values in a table format. When I SOQL to retrieve the data from that field through Dataloader, I got the result as "</td></tr><tr height=""20""><td colspan=""1"" rowspan=""1"" height=""20"" style=""height: 20px;"">. how to solve?
This would require post processing that is not something you can do with the Dataloader. Additionally, the "table data" you have is not valid and contains no information other than the HTML used to (incorrectly) render a cell of data. How are you loading this data into your field?
kirubakaran viswanathanActually in the custom application text field "Notes" , the user will copy the data manually from excel. If it has multiple rows/ cols data, while copy /paste, the data will paste as a table format in Salesforce. That is what we are facing an issue, while retrive using SOQL query.
You could write a trigger on the data to strip out the HTML or you could tell your users to be more careful.