Using powershell to strip RTF tags and return text.

• PretendDBA

  SSCrazy

  Points: 2060

  More actions

  January 11, 2021 at 8:28 am

  #3830779

  Hi, We've been looking to pull the text from a table in a vendor DB that stores in RTF format. I found a solution on a site but am having trouble getting it to work. It seems to work ok if I pass a result straight to it but if I try and use SQL to do the set for the @Stringrtf variable I get an error.

   

  SQL Server - How to Convert an RTF String to Text (Remove RTF Tags) Using CLR (C #) or Powershell - Dirceu Resende

   

• Phil Parkin

  SSC Guru

  Points: 247158

  More actions

  January 11, 2021 at 9:20 am

  #3830792

  PretendDBA wrote:

  Hi, We've been looking to pull the text from a table in a vendor DB that stores in RTF format. I found a solution on a site but am having trouble getting it to work. It seems to work ok if I pass a result straight to it but if I try and use SQL to do the set for the @Stringrtf variable I get an error.

  SQL Server - How to Convert an RTF String to Text (Remove RTF Tags) Using CLR (C #) or Powershell - Dirceu Resende

  What is your question?

  Clearly, we won't be able to help fix any of your T-SQL unless you show us what it is.

  ---

• PretendDBA

  SSCrazy

  Points: 2060

  More actions

  January 12, 2021 at 12:11 am

  #3831253

  Hi, I managed to work it out. Thanks though.