topic Re: Escape \n in QlikView

Escape \n

Saravanan_Desingh — Thu, 03 Mar 2016 22:34:47 GMT

I have a situation here. My text has something like below.

\\nabcdefgh

Here '\n' is considered as New-Line and I'm getting the output like below (split of line).

abcdefgh

Is there any work around? How to escape '\n' here?

Please advise.

Re: Escape \n

Peter_Cammaert — Thu, 03 Mar 2016 23:31:23 GMT

What will data like this be used for? If it's allowed to add a single space between the last backslash and the 'n' character, you could break the C-like interpretation of special characters. Like in:

=Replace('\\nabcdefgh', '\n', '\ n')

And note that this translation only happens at the display stage, not while manipulating data in fields.

Best,

Peter

Re: Escape \n

Saravanan_Desingh — Fri, 04 Mar 2016 01:13:21 GMT

Thanks, Peter. This is helpful.

It's just a text object to display some information. So, this should work.

Re: Escape \n

jagan — Fri, 04 Mar 2016 02:08:40 GMT

Hi,

You can replace it by using Replace() like below

=Replace('\\nabcdefgh', '\n', '')

You can do this in script like below

LOAD

Replace(FieldName, '\n', '') AS FieldName,

FROM DataSource;

Hope this helps you.

Regards,

Jagan.

Re: Escape \n

jagan — Fri, 04 Mar 2016 06:55:46 GMT

Hi,

If you got the answer close this thread by giving Correct and Helpful answers to the posts which helps you.

Regards,

Jagan.