Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Webskater
Starting Member
19 Posts |
 Posted - 2008-10-17 : 13:43:31
|
| I have a requirement for people to send heavily formatted emails - they paste a Word document into a 3rd party RTF type text box - bit like this one I am typing in - with buttons to set bold etc.I store the data they type (or paste) in - in a Text field in SQL Server. So the data in the field might look like ... <html><body><table border="0"><tr><td>Hello Fred</td></tr></table></body></html>I'd like to be able to get the data out of that field and display it as plain text. So I need to whip through it, find the character '<' and remove it and every other character between it and the next '>'.I'd also like to replace '<br>', '<br />' and '</p>' with a line feed and carriage return.No idea where to start. Appreciate any ideas.Thanks. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-10-17 : 14:02:08
|
| look into books online for REPLACE() function. |
 |
|
|
|
|
|
Strip html from field