Post reply

Identifying the html tags contained data in database table

  • November 15, 2007 at 9:30 am

    #62882

    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

  • November 15, 2007 at 9:49 am

    #751579

    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/[/url]

    ----------------------------------------------------------------------------------
    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?

  • November 17, 2007 at 8:14 pm

    #752087

    Hi Matt

    Thanks for suggestion

  • November 18, 2007 at 8:34 am

    #752100

    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.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply