Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
Thanks, Peter. This is helpful.
It's just a text object to display some information. So, this should work.
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.
Hi,
If you got the answer close this thread by giving Correct and Helpful answers to the posts which helps you.
Regards,
Jagan.