Convert RTF to varchar

• meichmann

  SSCommitted

  Points: 1900

  More actions

  August 17, 2018 at 11:37 am

  #376204

  Hi Everyone,
       I was wondering if anyone knew of a way to convert an RTF field to a regular varchar string.  Meaning, I need the RTF tags stripped, only bringing back the text.  I've been looking and can't seem to find any resources on it.

       Is there something I can put in my query that will do it on the fly?

  Thanks!

• Phil Parkin

  SSC Guru

  Points: 247140

  More actions

  August 17, 2018 at 11:50 am

  #2002304

  meichmann - Friday, August 17, 2018 11:37 AM

  Hi Everyone,
       I was wondering if anyone knew of a way to convert an RTF field to a regular varchar string.  Meaning, I need the RTF tags stripped, only bringing back the text.  I've been looking and can't seem to find any resources on it.

       Is there something I can put in my query that will do it on the fly?

  Thanks!

  Looks fairly challenging in T-SQL, but not so bad in C# – so a CLR, SSIS package or C# app will do it for you.

  ---

• meichmann

  SSCommitted

  Points: 1900

  More actions

  August 17, 2018 at 11:56 am

  #2002306

  Phil Parkin - Friday, August 17, 2018 11:50 AM

  meichmann - Friday, August 17, 2018 11:37 AM

  Hi Everyone,
       I was wondering if anyone knew of a way to convert an RTF field to a regular varchar string.  Meaning, I need the RTF tags stripped, only bringing back the text.  I've been looking and can't seem to find any resources on it.

       Is there something I can put in my query that will do it on the fly?

  Thanks!

  Looks fairly challenging in T-SQL, but not so bad in C# – so a CLR, SSIS package or C# app will do it for you.

  Hi Phil,
       Yeah, I'm trying to do it dynamically in the SQL query.  That's my only option at the moment, unless I can find a way to do it in SSIS.

• Phil Parkin

  SSC Guru

  Points: 247140

  More actions

  August 17, 2018 at 12:07 pm

  #2002308

  meichmann - Friday, August 17, 2018 11:56 AM

  Phil Parkin - Friday, August 17, 2018 11:50 AM

  meichmann - Friday, August 17, 2018 11:37 AM

  Hi Everyone,
       I was wondering if anyone knew of a way to convert an RTF field to a regular varchar string.  Meaning, I need the RTF tags stripped, only bringing back the text.  I've been looking and can't seem to find any resources on it.

       Is there something I can put in my query that will do it on the fly?

  Thanks!

  Looks fairly challenging in T-SQL, but not so bad in C# – so a CLR, SSIS package or C# app will do it for you.

  Hi Phil,
       Yeah, I'm trying to do it dynamically in the SQL query.  That's my only option at the moment, unless I can find a way to do it in SSIS.

  But if you had a CLR, you'd be able to call that from within your T-SQL. If this is going to be an ongoing requirement, I'd say that a CLR is your best option.

  ---

• meichmann

  SSCommitted

  Points: 1900

  More actions

  August 17, 2018 at 12:11 pm

  #2002311

  Phil Parkin - Friday, August 17, 2018 12:06 PM

  meichmann - Friday, August 17, 2018 11:56 AM

  Phil Parkin - Friday, August 17, 2018 11:50 AM

  meichmann - Friday, August 17, 2018 11:37 AM

  Hi Everyone,
       I was wondering if anyone knew of a way to convert an RTF field to a regular varchar string.  Meaning, I need the RTF tags stripped, only bringing back the text.  I've been looking and can't seem to find any resources on it.

       Is there something I can put in my query that will do it on the fly?

  Thanks!

  Looks fairly challenging in T-SQL, but not so bad in C# – so a CLR, SSIS package or C# app will do it for you.

  Hi Phil,
       Yeah, I'm trying to do it dynamically in the SQL query.  That's my only option at the moment, unless I can find a way to do it in SSIS.

  But if you had a CLR, you'd be able to call that from within your T-SQL. If this is going to be an ongoing requirement, I'd say that a CLR is your best option.

  Phil,
       ok I'll look into that.  thanks!