Identifying the html tags contained data in database table

SQLServerCentral is supported by Red Gate Software Ltd.

Home Articles Editorials Forums Scripts Blogs QotD Books SQL Jobs Training Authors About us Contact us Newsletters Advertise Write for us

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 7,2000 » T-SQL » Identifying the html tags contained data in...

Identifying the html tags contained data in database table

Rate Topic

Display Mode

Topic Options

Author

Message

Prasad K

Posted Thursday, November 15, 2007 9:30 AM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, April 21, 2009 11:13 AM
Points: 4, Visits: 17

Hi All,

In my database table there are some records with formatted with html tags and some plain.
Now i wanted find the records which are having html formatted tags. Is there any query to retrive these formatted data.

Please help me if anyone has idea on this.

Thanks

Post #422708

Matt Miller

Posted Thursday, November 15, 2007 9:49 AM

SSCertifiable

Group: General Forum Members
Last Login: 2 days ago @ 11:35 AM
Points: 5,734, Visits: 6,917

You can get a running start at it by filtering for things that contain <\. By far and large I don't think you will find that sequence "in the wild" a lot other than in markup language (although you might also pick up XML as well).

Otherwise try scanning for common tags in the field : TABLE, BR, P,

finally - if you want to search on a broad spectrum of tags - download the DBA toolkit from this web site, and use the Reg. Exp. tools to build your own HTML tag matcher. DBA toolkit for 2000 is here

http://www.sqlservercentral.com/articles/Advanced+Querying/sql2000dbatoolkitpart2/2362/

----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?

Post #422716

Prasad K

Posted Saturday, November 17, 2007 8:14 PM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, April 21, 2009 11:13 AM
Points: 4, Visits: 17

Hi Matt

Thanks for suggestion

Post #423362

Jeff Moden

Posted Sunday, November 18, 2007 8:34 AM

SSChampion

Group: General Forum Members
Last Login: Today @ 11:10 AM
Points: 16,211, Visits: 8,846

finally - if you want to search on a broad spectrum of tags - download the DBA toolkit from this web site, and use the Reg. Exp. tools to build your own HTML tag matcher. DBA toolkit for 2000 is here

Funny how things are... because of all the testing you and I did together, I was going to look for the tool kit right after I checked for new posts on the forums... didn't even have to look 'cause "ooouup, der it is!"

Thanks, Matt.

--Jeff Moden

"RBAR is pronounced "ree-bar" and is a "Modenism" for "Row-By-Agonizing-Row".

First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column."

For better, quicker answers, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Post #423378

« Prev Topic | Next Topic »

Permissions