1 Topic by Janet Simkin

  • Janet Simkin
  • Janet Simkin
  • Veteran
  • Offline
  • From: Northumberland
  • Registered: 10-05-2006
  • Posts: 262

Topic: Removing rtf formatting from comment fields

I used to have a nice little SQL script set up in MSE that would strip out the formatting from comments fields across the system, but lost it when I moved Recorder onto a new PC. Now I can't remember how to do it. Can anyone remind me?

Janet

Janet Simkin
British Lichen Society

Janet Simkin's Website

2 Reply by MikeWeideli

  • MikeWeideli
  • Administrator
  • Offline
  • From: Littlefield Consultancy
  • Registered: 05-07-2006
  • Posts: 2,645

Re: Removing rtf formatting from comment fields

There is a UDF which does it in R6.  dbo.ufn_RtfToPlaintext

Mike Weideli

MikeWeideli's Website