pyflink.table.expression.Expression.overlay

Expression.overlay(new_string: Union[str, pyflink.table.expression.Expression[str]], starting: Union[int, pyflink.table.expression.Expression[int]], length: Optional[Union[int, pyflink.table.expression.Expression[int]]] = None) → pyflink.table.expression.Expression[str]

Replaces a substring of string with a string starting at a position (starting at 1). e.g. lit(‘xxxxxtest’).overlay(‘xxxx’, 6) leads to ‘xxxxxxxxx’ lit(‘xxxxxtest’).overlay(‘xxxx’, 6, 2) leads to ‘xxxxxxxxxst’

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.