removing "\n" of a String in the RDLC report PlaceHolder!!!

Question

0.00/5 (No votes)

See more:

Hi i just want to created a RDLC report and i want to remove "\n" (newline constraint) from the string i got from database. then i wrote a Expression in the RDLC to remove it as follows

C#

=First(Fields!conAddress.Value, "HAWBDt").ToString().Replace("\n"," ")

but it didn't worked.

the String i got form the database as follows and i want to remove that "\n" from the String.

2nd FloorHolden House,\n57 Rathbone Place,\nLondon,\nUK

if anyone could help me on this matter that would be a great help to me.thanks in advance!!!

Posted 16-Aug-12 2:53am

Hesha

Updated 16-Aug-12 10:40am

Wendelius

v3

Add a Solution

Comments

[no name] 16-Aug-12 8:58am

It did not work because you are trying to get rid of a newline and it's a slash and an n in the string (not a newline).

Hesha 16-Aug-12 9:02am

yes.Agree.that's why i just put replace("\n", " ") so it should be replace? isn't it?

[no name] 16-Aug-12 9:07am

No! That is replacing the newline "\n". It is not a newline in your string is it? try \\n

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

E.F. Nijboer · Answer 1 · 2012-08-16T03:06:00

Solution 2

Try escaping the slash because you really mean a backslash in this case:

C#

=First(Fields!conAddress.Value, "HAWBDt").ToString().Replace("\\n"," ")

Good luck!

Posted 16-Aug-12 3:06am

E.F. Nijboer

Comments

Member 11704449 21-Jan-17 0:06am

thanks

E.F. Nijboer 23-Jan-17 18:30pm

Pretty old post, but happy it could still help you out :D