Links

URL_DECODE

Unescapes the given URL encoded value.
This function is the inverse of URL_ENCODE.
url_decode(value) → varchar#
Unescapes the URL encoded value. This function is the inverse of url_encode().

Syntax

URL_DECODE(VALUE)

Arguments

VALUE

Type: string
A URL encoded value.

Returns

Type: string
The decoded VALUE.

Examples

"SELECT url_decode('The+quick+brown+fox') = 'The quick brown fox' AND url_decode('Comment+%235') = 'Comment #5' AND url_decode('%26%24%23_line_%21123') = '&$#line!123' AND url_decode('') = '' AND url_decode('word%2Bword++word') = 'word+word word'"
VALUE
Output
The+quick+brown+fox
The quick brown fox
Comment+%235
Comment #5
%26%24%23_line_%21123
&$#_line_!123
''
''
word%2Bword++word
word+word word

Transformation job example

SQL

CREATE JOB function_operator_example
ADD_MISSING_COLUMNS = true
AS INSERT INTO default_glue_catalog.upsolver_samples.orders_transformed_data MAP_COLUMNS_BY_NAME
SELECT
URL_DECODE('The+quick+brown+fox') AS url_example1,
URL_DECODE('Comment+%235') AS url_example2
FROM default_glue_catalog.upsolver_samples.orders_raw_data
WHERE time_filter()
LIMIT 1;

Query result

url_example1
url_example2
The quick brown fox
Comment #5