tag:blogger.com,1999:blog-8370816780146195546.post8325389818098350662..comments2024-03-19T20:14:01.144+08:00Comments on SimplySfdc.com: How to create report in Salesforce with double quote in filterUnknownnoreply@blogger.comBlogger2125tag:blogger.com,1999:blog-8370816780146195546.post-12324263596771977642014-01-01T18:56:14.145+08:002014-01-01T18:56:14.145+08:00George, I just try SOQL below and it works with no...George, I just try SOQL below and it works with no issue.<br />SELECT Id, Name FROM Contact WHERE LastName LIKE '%\"bob the builder%'<br />See this screenshot for the result<br />https://na3.salesforce.com/sfc/p/300000000SHq/a/50000000H0vV/sXvFUTZiGiTY1oWwNy7c2HDY.3qBd9HRumbFwpMxcK4=<br />Johan Yuhttps://www.blogger.com/profile/09877402459810490900noreply@blogger.comtag:blogger.com,1999:blog-8370816780146195546.post-23869156871307179972013-12-31T12:39:11.178+08:002013-12-31T12:39:11.178+08:00I need to do exactly the same thing. Basically I a...I need to do exactly the same thing. Basically I am scan a field containing JSON data which of course includes double-quotes. Unfortunately even when I try it in the Query Editor by putting like like '%\"bob the builder%' it returns nothing as if it is not running at all.<br />Anonymousnoreply@blogger.com