Skip to content

Instantly share code, notes, and snippets.

View DamienAstolfi's full-sized avatar

Astolfi Damien DamienAstolfi

View GitHub Profile
@patpawlowski
patpawlowski / RTF2TXTfn.sql
Last active February 14, 2024 16:00
VERY simple SQL RTF to TXT converter primarily to convert Act notes to plain text
/*
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.