pyflink.table.expression.Expression.json_unquote

Expression.json_unquote() → Expression

Unquotes JSON value, unescapes escaped special characters (‘”’, ‘’, ‘/’, ‘b’, ‘f’, ‘n’, ‘r’, ‘t’, ‘u’ hex hex hex hex) and returns the result as a string. If the argument is NULL, returns NULL. If the value starts and ends with double quotes but is not a valid JSON string literal, an error occurs.

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.