HTML markup code

Wed, 25 Nov 2020 16:16:04 GMT

how to strip Html code from data field.

Re: HTML markup code

everest226 — Thu, 01 Dec 2016 01:03:25 GMT

Step 1: In your extract QVW, add the below VB code under tools Edit module,

change Requested module security to system access and allow system access

Function stripHTML(strHTML)

'Strips the HTML tags from strHTML

Dim objRegExp, strOutput

Set objRegExp = New Regexp

objRegExp.IgnoreCase = True

objRegExp.Global = True

objRegExp.Pattern = "<(.|\n)+?>"

'Replace all HTML tag matches with the empty string

strOutput = objRegExp.Replace(strHTML, "")

'Replace all < and > with < and >

strOutput = Replace(strOutput, "<", "<")

strOutput = Replace(strOutput, ">", ">")

stripHTML = strOutput 'Return the value of strOutput

Set objRegExp = Nothing

End Function

Step 2: in edit script, after the field

replace(replace(stripHTML([content/properties/Your filed name])

,':',':')

,' ',' ') as newcleanfiledname,

Thu, 01 Dec 2016 01:06:20 GMT

Thanks everest226‌ is there anyway to do that in script