sql server - How can I extract human-readable text from a code snippet? -

i need write t-sql query against text column of values html or asp.net coding include normal human-readable text. example:

{\colortbl ;\red31\green73\blue125;\red0\green0\blue0;} \viewkind4\uc1\pard\ltrpar\lang1033\f0\fs22 invoices emailed jack jack.marsman@brampton.ca 

i don't need information need real text; in case want all invoices emailed jack jack.marsman@brampton.ca

any suggestions on how go extracting text without getting coding?

short answer there no easy standard way this. i’d try creating clr since kind of parsing easier in c# or vb.net.

you can try using regex strip out that’s not human readable.

is of data in similar format shown? if that’s case comes down calling substring several times…