function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
kirubakaran viswanathankirubakaran 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?
pconpcon
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 viswanathankirubakaran viswanathan
Actually 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.
pconpcon
You could write a trigger on the data to strip out the HTML or you could tell your users to be more careful.