Geek asks and answers

Structuring a Gdata Spreadsheet Request

I am trying to create Zend_Gdata_Spreadsheets_ListQuery, and I can not find links explaining what the syntax of the expected request is and what types of requests you can and cannot fulfill. The closest I could find is the [Google Data Data API Clinical Library (1.41.1)] (https://developers.google.com/gdata/javadoc/com/google/gdata/client/spreadsheet/ListQuery # ListQuery (java.net.URL)), which describes the setSpreadsheetQuery function as follows:

setSpreadsheetQuery

public void setSpreadsheetQuery (query java.lang.String) Sets a structured spreadsheet query. Parameters: query - a query such as "name = 'Sonja' and state = 'Georgia'

This works fine if you are looking for a cell whose column name is "name" and contains the text "Sonja" and nothing more. I am looking for cells containing "Sonja" as part of the cell text. For example, a cell in the "name" column with the value "Sonja Awesome" does not match the search above. name = Sonya * causes an error, and name = "Sonya *" does not return results.

So, does anyone know where I can find a summary of what the expected "structure" for a "structured spreadsheet query" is?

+5
source share
1 answer

Have you tried using regex? Also, be sure to avoid special regular expression characters. Something like \ bSonja \ b

0

More articles:


All Articles