Encoding/Escaping & Decoding/Unescaping with JScript

Fri, 02 Dec 2011 22:27:18 GMT

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

topic Encoding/Escaping & Decoding/Unescaping with JScript in QlikView