URL_DECODE
Syntax
URL_DECODE(<URLÂ string>)
Description
Decodes an encoded string. It is assumed that all characters in the encoded string are one of the following: "a
" through "z
", "A
" through "Z
", "0
" through "9
", and "-
", "_
", ".
", and "*
". The character "%
" is allowed but is interpreted as the start of a special escaped sequence.
The default for <character_encoding:string> is UTF-8.
Examples
Column1 | URL_DECODE returns |
---|---|
http%3A%2F%2Fgoogle.com%2F | http://google.com/ |
http%3A%2F%2Fwww.datameer.com%2Fproduct%2Findex.html | http://www.datameer.com/product/index.html |
http%3A%2F%2Fwww.datameer.com%2FDatameer-trial.html | http://www.datameer.com/Datameer-trial.html |