Post reply

get rid of HTML Tags in NTEXT Field

  • March 27, 2002 at 8:55 am

    #78913

    Hi,

    I was wondering if there's an easy way to get rid of HTML tags in a NTEXT Field.

    Thanks

    Edited by - Dirkson on 03/27/2002 09:08:10 AM

    http://www.dwexplorer.com
    @dtwegener

  • March 27, 2002 at 9:09 am

    #426175

    You could use REPLACE function for each possiblity.

    Ex. REPLACE(fldName,'<HTML>','')

    But if you can be more specific exactly what is in the field might have something better out there.

    "Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

  • March 27, 2002 at 9:12 am

    #426176

    Unfortunately that is not possible since the data is in a field which is of the NTEXT Data Type.

    http://www.dwexplorer.com
    @dtwegener

  • March 27, 2002 at 9:24 am

    #426179

    Duh, I read that, I guess it is time to go back to sleep. I will look around, I saw code like this here somewhere on how to search and replace in NTEXT, TEXT fields.

    "Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

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

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