how to use replace string?

Question

4.00/5 (1 vote)

See more:

I am trying to replace the html tags "b" & "p" from my text and with the following code below, I am getting the output of my text with the html tags.

C#

public string GetArticleText()
    {
    string htmlStr = "";
    string strConnectionString = ConfigurationManager.ConnectionStrings["######"].ConnectionString;
    SqlConnection thisConnection = new SqlConnection(strConnectionString);
    SqlCommand thisCommand = thisConnection.CreateCommand();
    thisCommand.CommandText = "############";
    thisConnection.Open();
    SqlDataReader reader = thisCommand.ExecuteReader();
    while (reader.Read())
    {
        string Name = reader.GetString(0);
        string Pass = reader.GetString(1);

        Pass = Pass.Replace("<br>", "");
        Pass = Pass.Replace("<p>", "");
        Pass = Pass.Replace("</p>", "");
        htmlStr += "<tr><h2>" + Name + "</h2></tr><tr>" + Pass + "</tr>";
    }

    thisConnection.Close();
    return htmlStr;
    }

Client-side:

HTML

<table width="100%" align="center" cellpadding="2" cellspacing="2" border="0" >
       <%=GetArticleText()%>
   </table>

Is there something i missing or doing incorrectly in my above code? please advice. Thanks.

Posted 17-Oct-14 1:04am

miss786

Updated 17-Oct-14 6:08am

v3

Add a Solution

4 solutions

Solution 1

XML

Pass = Pass.Replace("<br>", "");
Pass = Pass.Replace("<p>", "");
Pass = Pass.Replace("</p>", "");

Check what tag is used <br> or <br/>

Posted 17-Oct-14 1:11am

MukeshSagar

Comments

miss786 17-Oct-14 7:27am

Thank you for your reply. I have corrected the tags for , but it still appearing on the client-side. Please advice further.

MukeshSagar 17-Oct-14 7:49am

Show the screen shot of the output, so that i can suggest solution

miss786 17-Oct-14 10:10am

Thank you for your reply & apology for the late response. I have copied the output as text, in my above post for further reference. I was unable to attach screenshot of my output, as I could not find option, on the forum to do so.

I also would like to inform, I am insert the articles into database using "tinymce'' text editor, could this be the reason, why the 'replace' string is not rendering correctly? Thank you

Solution 2

HTML

Pass = Pass.Replace("<br>", "");
Pass = Pass.Replace("</br>", "");
Pass = Pass.Replace("<p>", "");
Pass = Pass.Replace("</p>", "");

Posted 17-Oct-14 3:53am

majid torfi

v2

Comments

miss786 17-Oct-14 10:11am

Hi, thank you for your help. Sadly, I have already tried this above in my code, which does not remove the html tags on the client-side.

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)

Sheepings · Accepted Answer · 2014-10-17T06:42:00

String.Replace will work but you can also look at String.Remove. In your code you are receiving data from a reader, and then replacing the html.

Prevention is better than cure, so I would suggest that you remove it from where you are inserting it from. Take the contents from the tinymce editor and send it to a new string variable and use the method below.

C#

String HtmlLine = "</br>";
String NormalLine = HtmlLine.Replace("</br>", "");

Or If there is lots of html elements to remove

HTML

</br>

, then iterate through the words in the string and remove each occurrence of html on the fly. You could use a Select Case or If statement to check for Html entries in the words and remove them using the methods mentioned above accordingly.

While iterating each word that is now not html; add each word to a dictionary, and then reiterate the dictionary values to retrieve your sentence from the first dictionary key to the last dictionary key. You can then construct your new string without html and add it to your database. See a reference of dictionary here.

There are a hundred other options to do this, in many different ways.

The simplest would be to use a If statement to check for html entries and remove them by iterating each word. You can find many results on iterating each word on Google.

C#

String HtmlLine = "</br>";
String NormalLine = HtmlLine.Replace("</br>", "");

Hope this helps. If you have any questions, let me know.

If you found this helpful, please mark it as a solution.

Pascal-78 · Accepted Answer · 2014-10-17T05:04:00

if  and others are displayed in your browser, it must not be present as this in the actual string.

For example, to get the displayed in my solution, I have entered  ( < for < and > for >)

If your source string (in your database) contains those strings, your browser will interpret those and will display the interpreted string. To be sure of this, you can look at the source code of your page (by pressing F12 in most browser).

And to correct your problem, you may have to replace :
-  rather than 
-  rather than 
but you have a lot of other special strings. (& is & for example.)

how to use replace string?

4 solutions

Solution 4

Solution 3

Solution 1

Solution 2

Add your solution here

Preview 0