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 |