Google Spreadsheets DAVERAGE database function criteria syntax: substring match? -

Google Spreadsheets DAVERAGE database function criteria syntax: substring match? -

can daverage write restriction in filter filter matches database row if restriction text matches either or substring? example: restriction b column x default matches rows b in column x not rows cab. can wildcard/prefix/etc restriction b match cab?

(set aside alternative create 1 filter row b, 1 cab, ... since tedius when there many different target strings b in them.)

google's database functions helppage says:

the first row in criteria specifies field names. every other row in criteria represents filter, set of restrictions on corresponding fields. restrictions described using query-by-example notation, , can include value match or comparing operator followed comparing value. examples of restrictions are: "chocolate", "42", ">= 42", "<> 42". empty cell means no restriction on corresponding field. filter matches database row if filter restrictions (the restrictions in filter's row) met. database row (record) satisfies criteria if , if @ to the lowest degree 1 filter matches it. field name may appear more 1 time in criteria range allow multiple restrictions apply simultaneously (for example, temperature >= 65 , temperature <= 82)."

google's example spreadsheet.

yes can utilize wild cards dfunctions. might utilize criteria:

"*b*"

function google-apps-script google-spreadsheet