Discussion Board for collaboration related to Creating Analytics for QlikView.
I have a situation here. My text has something like below.
Here '\n' is considered as New-Line and I'm getting the output like below (split of line).
Is there any work around? How to escape '\n' here?
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.
Thanks, Peter. This is helpful.
It's just a text object to display some information. So, this should work.
You can replace it by using Replace() like below
=Replace('\\nabcdefgh', '\n', '')
You can do this in script like below
Replace(FieldName, '\n', '') AS FieldName,
Hope this helps you.
If you got the answer close this thread by giving Correct and Helpful answers to the posts which helps you.