pyflink.table.expression.Expression.position

Expression.position(haystack: Optional[Union[str, pyflink.table.expression.Expression[str]]] = None) → pyflink.table.expression.Expression[int]

Returns the position of string in an other string starting at 1. Returns 0 if string could not be found. e.g. lit(‘a’).position(‘bbbbba’) leads to 6.

See also

trim_leading(), trim_trailing(), trim(), replace(), char_length, upper_case, lower_case, init_cap, like(), similar(), position(), lpad(), rpad(), overlay(), regexp_replace(), regexp_extract(), substring(), from_base64, to_base64, ltrim(), rtrim(), repeat(), json_quote(), json_unquote()

New in version 1.12.0.