topic Re: Variables containing \n in QlikView

Variables containing \n

thomduvi83 — Wed, 24 Jul 2013 13:21:49 GMT

Hi,

I have a variable containing a network path (UNC) starting with "\\n...".

If i want to show it in a text box, the "\n" is always interpreted as a carriage return.

I also would like to "info load" file paths starting with this but no better luck.

Anyone has an idea how to avoid this return, but still displaying the correct value (and without changing the network path name...) ?

Can we disable this automatic carriage return interpretation ?

Already tried : adding chr(00),chr(02),... between "\" and "n", going through a field value (displayed correctly in a listbox but not in a text obj.)

Thanks in advance,

Thomas

marcus_sommer — Wed, 24 Jul 2013 14:03:05 GMT

I don't know how it could be to mask, but perhaps is a workaround with upper(var) enough.

- Marcus

thomduvi83 — Wed, 24 Jul 2013 14:09:57 GMT

What a glorious idea ! I'm blaming myself to not tried that...

I've not yet tried it for the "info load" but i have good hopes, as folder paths are not case sensitive.

Thanks,

Thomas