I have successfully searched, using visualization API coupled with javascript, my google spreadsheet and returned expected results My issue now is I am searching a row of numbers with an ampersand in it. The number reads like so: *S&D01234*
I have tried two methods to search for the number; 1.) using encodeURIComponent 2.) replace & with the unicode - U+0026 there is now error with either of these methods, but it returns headers only with no data. I also alerted the value of my var in both cases, they were: 1.) S%26D01234 portion of the rendered URL: SELECT+A,+B,+C,+D,+E,+F,+G,+H,+I,+J+WHERE+F+CONTAINS+%27S%26D01234%27&gid=0 2.) SU+0026D01234 portion of the rendered URL: SELECT+A,+B,+C,+D,+E,+F,+G,+H,+I,+J+WHERE+F+CONTAINS+%27SU+0026D01234%27&gid=0 Neither works. Any ideas? Robert -- You received this message because you are subscribed to the Google Groups "Google Visualization API" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/google-visualization-api. To view this discussion on the web visit https://groups.google.com/d/msgid/google-visualization-api/690f87a8-54e2-453d-9182-07fce64fbe42%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
