Secial Character ']'

[#1]

Hi All,

Could you please help here.

Currently we are getting the special character ‘]’ as a value from the table we need to store this in a Inline a table for logic we are using.

We want the character should be retained and cant replace it.

Please find the sample code below

set y = 'testd]atsa';

set x = 'xy]';

LOAD * INLINE [

    F1, F2

    $(y),    $(X)

];

Thanks & Regards

Mallikarjuna

[whiteline]

Hi.

You could use another char with inline and replace it properly later:

let y = 'testd' & chr(1) & 'atsa';

let x = 'xy' & chr(1);

LOAD

     replace(F1, chr(1), ']') as F1,

     replace(F2, chr(1), ']') as F2

INLINE [

     F1, F2

    $(y),    $(x)

];

[#3]

Hi,

http://community.qlik.com/message/173404#173404

set y = 'test]data';

set x = 'xy]';

LOAD * INLINE

"F1, F2

$(x), $(y)

";

Not a perfect solution...

Best regards

[#4 · Accepted solution]

You can try this....

LET y = replace('test]data',']','^');

LET x = replace('xy]',']','^');

Load Replace(F1,'^',']'),Replace(F2,'^',']');

LOAD * INLINE
[
F1, F2
'$(y)',       '$(x)'
];