HTML markup code

[#1]

how to strip Html code from data field.

[everest226 · Accepted solution]

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 &lt; and &gt;

  strOutput = Replace(strOutput, "<", "&lt;")

  strOutput = Replace(strOutput, ">", "&gt;")

  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])

        ,'&#58;',':')

        ,'&#160;',' ') as newcleanfiledname,

[#3]

Thanks everest226‌ is there anyway to do that in script