decode_uri(str: string) -> string

Replace %-encoded escape sequences in a string with unencoded plain text.

However, encoded characters in the set #$&+,/:;=?@ are kept encoded. NULL if input contains an invalid encoded sequence.

See also decode_uri_component, decode_base64.

Domain

This is a scalar function (calculates a single output value for a single input row).

Categories

• String

Examples

make_col d:decode_uri('%32%5E%33%20%3D%20%38%3B')

Decoding the example string results in '2^3 %3D 8%3B' which is different from decode_uri_component.