topic Re: How to remove html text? in QlikView

How to remove html text?

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have created a odbc connection and there are some fields that have html code in them. Do you know an easy way to remove the html code to be displayed on qlikview?

I have found the following:

1. Go to Tools >Edit Module, add the following:

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

2. In Edit Script, after the field type:

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

,':',':')

,' ',' ') as newcleanfiledname,

But this didn't work for me. Any idea?

Thanks,

Re: How to remove html text?

jonathandienst — Mon, 01 Aug 2016 13:05:19 GMT

It depends on how complicated the HTML text is. If its a fairly consistent pattern, you may be able to get away with using the built-in string handling functions.

If that is not practical, a module function using Regexes should work, but clearly requires some debugging. Test the module with sample data from your source by sprinkling with MsgBoxes to see what it is doing, and where it may be going wrong.

Re: How to remove html text?

jonathandienst — Mon, 01 Aug 2016 13:07:42 GMT

These two lines may be the wrong way round:

'Replace all < and > with < and >

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

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

'The HTML will contain < and >

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

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

Re: How to remove html text?

jonathandienst — Mon, 01 Aug 2016 13:09:04 GMT

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

This field name looks like something from an XML load. If the HTML is well formed, then this another way to read the data, but you will not need the model functions.

Re: How to remove html text?

Anonymous — Mon, 01 Aug 2016 15:01:10 GMT

Ok, this is what I have, for example one of my fields is the following:

<p>Test, this is a test for qlikview.$nbsp;</p>

<p> This is another test for qlikview~530</p>

How can modify the code to remove the html code?