Post reply

Sharepoint Text field - how to hide the html?

  • June 27, 2013 at 8:47 am

    #295089

    I am writing a report based on a sharepoint list, and my text field displays with all of the formatting code. It shows everything between the < and > as shown in the attached image. I can't find a function to hide this and make the text display correctly in the report. I'm using a text box - should another object type be used?

    Thanks in advance...

  • June 27, 2013 at 9:28 am

    #1628032

    in other programming situations, I've used a Regular Expression to strip html tags out of a field, leaving just the content; would that be a possibility?

    then you could do Field=StripHtml(SomeValue)

    Public Function StripHTML(ByVal s As String) As String

    Return Regex.Replace(s, "<(.|)*?>", String.Empty)

    End Function

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • June 27, 2013 at 9:55 am

    #1628048

    I found a solution on http://technet.microsoft.com/en-us/library/cc627491.aspx

    that did the trick. If you simply drag a data item over from your dataset you don't get this option, but if you first add a Text box and then associate a data item with it, you can format as html or not.

    Thanks for the suggestion Lowell..

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply