Word Report replacing “block character” (□) carriage returns issue using asp.net

Question

0.00/5 (No votes)

See more:

I am generating word report using asp.net. I am exporting data from the database and replacing it with the placeholders in the word document. When i am retrieving the data from the database the string contains the "block character" (□) carriage returns which i want to eliminate? I have tried replacing it with chr(11), chr(13) but have not got any success. for example i have the following text
abc
xyz
then the current output i am getting is as follows:
abc
□ xyz
instead of
abc
xyz
on word report. Can you please provide me with a solution for the above issue?

Posted 24-May-11 21:30pm

piyush_verma3

Updated 26-May-11 2:44am

v2

Add a Solution

Comments

Sandeep Mewara 25-May-11 5:15am

Can you be a little more elaborate and explain what are you trying? (Update the question with details using 'Improve Question' link)

Sergey Alexandrovich Kryukov 25-May-11 9:58am

Please don't post anything as Solution if it is not a solution.
Use "Improve question", "Add comment" or reply to a comment.
--SA

2 solutions

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)

**R. Giskard Reventlov** · Answer 1 · 2011-05-25T04:03:00

Solution 2

Try using Environment.NewLine rather than "\r\n".

Posted 25-May-11 4:03am

R. Giskard Reventlov

v2

piyush_verma3 · Answer 2 · 2011-05-30T19:17:00

Solution 3

I have tried using it but the box (blocking character)still exists in the string. Is there any other way to eliminate the blocking character?

Posted 30-May-11 19:17pm

piyush_verma3