The Tools.exe has functionality to convert RTF fields into Plain Text. This is, for example, necessary to convert old Estimator Notes to the Note in the Status bar of the Quotes in ver 9.
Note
The QUOTEMAIN.NOTE field is also a BLOB field, so the QUOTEDESC.NOTE field can be copied directly into the QUOTEMAIN.NOTE field without truncating it.
It only takes around 15 seconds to convert the 15k records on Remata DB
Always make a backup before executing a script or making batch updates to a DB.
Get Started
Add the variables required and click 'Open' to fetch the records that need to be converted.
Click 'Convert' and the Plain Text should now match the Rich text.