Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
You can try this....
LET y = replace('test]data',']','^');
LET x = replace('xy]',']','^');
Load Replace(F1,'^',']'),Replace(F2,'^',']');
LOAD * INLINE
[
F1, F2
'$(y)', '$(x)'
];
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)
];
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
You can try this....
LET y = replace('test]data',']','^');
LET x = replace('xy]',']','^');
Load Replace(F1,'^',']'),Replace(F2,'^',']');
LOAD * INLINE
[
F1, F2
'$(y)', '$(x)'
];