pyflink.table.expression.Expression.overlay

Expression.overlay(new_string: str | Expression[str], starting: int | Expression[int], length: int | Expression[int] | None = None) → 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()

Added in version 1.12.0.