Encoding/Escaping & Decoding/Unescaping with JScript

[#1]

New to Qlikview. I was trying to find a way to unescape data from a SQL database, here is my solution:

Jscript:

Open the Macro Editor and select JScript.

Encoding:

function encode( str ) {

  return encodeURI(str);

}

Decoding:

function decode( str ) {

  return decodeURI(str);

}

Escaping:

function escape( str ) {

  return escape(str);

}

Unescaping:

function unescape( str ) {

  return unescape(str);

}

In the script editor, when loading variables simply call the function:

LOAD var1,

          unescape(var2) as var 2,

          ..

          var10;

SQL ...

Hope this helps someone.

Regards,

Benjamin