Strip out human-readable text from a code?

Ive been given a task to create a t-SQL query against a text column. Some of the values in this column contain an html code but there is also a human-readable text included.

E.g.: \color table; \yellow22\ blue45\gray112\; \yellow0\blue0\gray0; Email all admin accounts to john_doe@email.com

I dont need all this stuff. All I need is: Email all admin accounts to john_doe@email.com

So, how to extract just this human-readable text from coding text?

July 8th, 2013 5:15am

I recommend you try making Common Language Runtime procedure because parsing of such a type is simpler in vb.net or c#.

Also, you can experiment with regular expressions to remove any text that is not human readable.

All in all there is no easy way to get this done.

Free Windows Admin Tool Kit Click here and download it now
July 8th, 2013 5:22am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics