lrnewell-au
patpawlowski
/ RTF2TXTfn.sql
Last active
March 27, 2025 01:45
VERY simple SQL RTF to TXT converter primarily to convert Act notes to plain text
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| /* | |
| Written by: patpawlowski | |
| Created On: Oct 26, 2015 at 4:51:52 PM | |
| Description: This is a rough attempt to create a funciton to strip the markup from | |
| the Act TBL_NOTE.NOTETEXT field. It appears to work for what I need | |
| but could probably use some work with the escaped characters. | |
| It's not particularly fast but it is faster than other solutions I've come | |
| across. It takes about 4 seconds to parse 2700 records. |