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 |
|
naidu4u
Starting Member
23 Posts |
 Posted - 2010-09-28 : 12:12:33
|
| Am a cognos developer but when am trying to display a column from database directly its showing some unnecessary tags and my team leader told me to write the database function to get rid of that mess. The data am getting is like thisComment:some useful information, </br>again some more info </br>again some info </br><span style="font-family: arial;"> some useful info </span> and so on in almost all the rows in that column.Please help me with some function to get rid of these </br>, <span> and other messy data.Thanks in advance. |
|
|
Skorch
Constraint Violating Yak Guru
300 Posts |
Posted - 2010-09-28 : 12:58:35
|
| It sounds like you need to clean up the process that inserts this garbage into the database rather than cleaning the data already in there. Those HTML tags should not be making it into the database in the first place.Some days you're the dog, and some days you're the fire hydrant. |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
naidu4u
Starting Member
23 Posts |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
|
|
|
getting unnecessary data in a column
MadhivananFailing to plan is Planning to fail