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

Column1URL_DECODE returns
http%3A%2F%2Fgoogle.com%2Fhttp://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.htmlhttp://www.datameer.com/Datameer-trial.html