Hello,
I'm trying to clean up data from the source database before migrating it into the EPiServer database. I would like to strip all HTML tags from values before I put them into the PageName. I've added a regular expression but it doesn't seem to match any of the tags including br, span, b, etc.
The SQL is something like this:
DECLARE @regex VARCHAR(8000)
SET @regex = '\<.+?\ />' -- Not sure about the regular expression that I need to put here.
SELECT
REPLACE(varCharType, @regex ,'') as PageName,
MainBody
FROM tbl_TextProperties
I appreciate your help.
Thanks.
Victor
DECLARE @regex VARCHAR(8000) SET @regex = '\<.+?\ />' -- Not sure about the regular expression that I need to put here. SELECT REPLACE(varCharType, @regex ,'') as PageName, MainBody FROM tbl_TextProperties
I appreciate your help. Thanks. Victor