topic Re: Secial Character ']' in QlikView

Secial Character ']'

Mon, 05 Nov 2012 08:00:11 GMT

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

Re: Secial Character ']'

whiteline — Mon, 05 Nov 2012 08:17:58 GMT

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)

];

Re: Secial Character ']'

Mon, 05 Nov 2012 08:34:02 GMT

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

Re: Secial Character ']'

Mon, 05 Nov 2012 12:45:42 GMT

You can try this....

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

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

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

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