Reference
No results for 'undefined'
    Powered by Algolia

    TEXT_TEMPLATE

    Substitutes question marks in the provided string with param values. Parameters can be named: in that case, provide a frame with matching column names as a values argument.

    Syntax

    =TEXT_TEMPLATE(template, paramValue, paramValue, ...)

    Parameters

    1. template
      • Type: String
      • Description: The text template.
    2. paramValue [repeatable]
      • Type: Any
      • Description: Param values.

    Returns

    • Type: String
    • Description: Returns a new text based on the template fulfilled with parameter values

    Example

    =TEXT_TEMPLATE("SELECT * FROM table WHERE string_field = '?' AND numeric_field > ?", "string value", {42})
    =TEXT_TEMPLATE("SELECT * FROM employees WHERE first_name='?name'",FLIP_FRAME(B11:C11))

    Try It Now

    Sorry, your browser is not supported. MINTDATA™ works best on Google Chrome 50.0+ and Firefox 44.0+.

    See Also

    Contents