Well, I ended up altering the actual data which now reads SD01234, but even the basic pull out all data removes the SD01234 from the cell before returning the results.
Any help? Robert On Friday, March 16, 2018 at 2:09:28 PM UTC-7, Robert Adams wrote: > > 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/1c9d61e0-7fd0-4e16-a3c1-9f3bf00db40d%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
