Post reply

Regex Expression to remove RTF tags

  • March 8, 2013 at 6:25 am

    #394344

    Hi There,

    I have a file that I get from pulling out values from a Microsoft Lync 2013 conversation that has RTF formatting tags. An example file would be like:

    Here is my file:

    {\rtf1\fbidis\ansi\ansicpg1254\deff0ouicompat\deflang1055{\fonttbl{\f0\fnil\fcharset162 Segoe UI;}{\f1\fnil\fcharset238 Segoe UI;}{\f2\fnil Segoe UI;}}

    {\colortbl ;\red0\green0\blue0;}

    {\*\generator Riched20 15.0.4420}{\*\mmathPr\mwrapIndent1440 }\viewkind4\uc1

    \pard\cf1\embo\f0\fs20 emaillerini\embo0 \embo al \embo0 \f2\par

    {\*\lyncflags rtf=1}}

    I want to remove RTF tags and and just pull out the text of the conversation. So the result of my function should be:

    emaillerini al

    BTW, I been using Microsoft SQL Server Report Builder for that. I have a expression like below and but it's not working.

    =SWITCH(Fields!ContentType.Value = "text/rtf",Code.ConvertRtfToTextRegex(Fields!Body.Value),

    Fields!ContentType.Value = "text/plain",Fields!Body.Value,

    Fields!ContentType.Value = "text/html",System.Text.RegularExpressions.Regex.Replace(Fields!Body.Value, "\<[^\>]+\>", ""),

    Fields!ContentType.Value <> "", Fields!Body.Value

    )

    Thanks & Regards,

  • March 13, 2013 at 12:03 pm

    #1596645

    Any suggestions?

  • March 13, 2013 at 1:56 pm

    #1596697

    Sel what I've done myself is to create a CLR function that returns RTF2Text, or vice versa;

    that's the best way i know of, because the RichTextBox from windows.forms handles ALL the rules you might miss with more complex RTF documents, by just doing string manipulation.

    If it's an option, i can post an example project.

    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!

  • March 13, 2013 at 4:16 pm

    #1596739

    Lowell (3/13/2013)

    Sel what I've done myself is to create a CLR function that returns RTF2Text, or vice versa;

    that's the best way i know of, because the RichTextBox from windows.forms handles ALL the rules you might miss with more complex RTF documents, by just doing string manipulation.

    If it's an option, i can post an example project.

    First of all thanks for your response. can you please give me an example project? Secondly how do I accommodate to my project your project? Please clarify.

    My project is here : https://skydrive.live.com/#cid=2FA6294B3E381151&id=2FA6294B3E381151!128

    Thanks,

  • March 15, 2013 at 1:35 pm

    #1597655

    Any suggestions ?

  • April 19, 2013 at 1:23 pm

    #1608373

    I'm assuming this reply is too late for your use but in case anyone else needs...

    This works well for me:

    \\\w+|\{.*?\}|}

  • April 21, 2013 at 7:25 am

    #1608543

    erik 25824 (4/19/2013)

    I'm assuming this reply is too late for your use but in case anyone else needs...

    This works well for me:

    \\\w+|\{.*?\}|}

    Like you said , I've changed regex expression. But I've having same problem. Can you send me the report file which is rdl extension that you are using?

    Regards and thanks,

Viewing 7 posts - 1 through 7 (of 7 total)

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

Cookies on SQLServerCentral

This website stores cookies on your computer.

These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.

To find out more about the cookies we use, see our Privacy Policy