topic Re: Issue with stripHTML function in QlikView in QlikView

Issue with stripHTML function in QlikView

apoorvasd — Fri, 17 May 2019 12:31:24 GMT

Hello Everyone,

I am trying to eliminate html codes from my data using stripHTML function. I am using the below macro for the same,

Function stripHTML(strHTML)
'Strips the HTML tags from strHTML

Dim objRegExp, strOutput
Set objRegExp = New Regexp

objRegExp.IgnoreCase = True
objRegExp.Global = True
objRegExp.Pattern = "(?:<style.+?>.+?</style>|<script.+?>.+?</script>|<(?:!|/?[a-zA-Z]+).*?/?>)"

'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

The issue is, when I reload the report locally in my server, the report executes without any errors, but when reloaded on QMC, I get the below error

Any guesses what could be the possible reason for this?

Thank you.

Re: Issue with stripHTML function in QlikView

Anil_Babu_Samineni — Fri, 17 May 2019 12:40:36 GMT

Where did you given this script? In the module side or Somewhere? If module side, what is the usage of this?

Re: Issue with stripHTML function in QlikView

jonathandienst — Fri, 17 May 2019 12:47:30 GMT

The function looks OK to me (not tested).

Please show the code that invokes the function. Its possible that the function is returning an empty string which is causing another problem.

Do you know which line is throwing the error?

Re: Issue with stripHTML function in QlikView

apoorvasd — Mon, 20 May 2019 05:18:23 GMT

Hello,

I am calling it this way at script side,

Replace(Replace(stripHTML(Remarks), '&#58', ''), '&#160', '') as Remark_PS,

Also just tried to call this expression in a text box to see if I can find any error. Looks like a syntax issue, is it?

Thank you.

Re: Issue with stripHTML function in QlikView

apoorvasd — Mon, 20 May 2019 05:21:45 GMT

Hello,

Yes, I have written this as a module script. As far as I know it is required to invoke the StripHTML function.

Thank you.

Re: Issue with stripHTML function in QlikView

jonathandienst — Mon, 20 May 2019 06:40:57 GMT

Have you tested the regex pattern?

It throws errors in a tool like regxr.com for unescaped '/' characters. The error could be coming from the Match() command with a bad pattern. Try:

(?:<style.+?>.+?<\/style>|<script.+?>.+?<\/script>|<(?:!|\/?[a-zA-Z]+).*?\/?>)

This is valid, but may not be semantically correct. I suspect you need some more parentheses and the third non capture group is not clear. I assume you want to match the opening and optional closing html tags?

Re: Issue with stripHTML function in QlikView

apoorvasd — Mon, 20 May 2019 06:29:13 GMT

Hmm...no i haven't tested the regex pattern! Where can I check this?

I tried your new pattern, it isn't working and throwing up the same error!

Any other suggestion?

Thank you.

Re: Issue with stripHTML function in QlikView

jonathandienst — Mon, 20 May 2019 06:42:35 GMT

regxr.com is one on line tester. There are others

Re: Issue with stripHTML function in QlikView

apoorvasd — Mon, 20 May 2019 06:45:39 GMT

Okay, will check that. Thank you.

Re: Issue with stripHTML function in QlikView

marcus_sommer — Mon, 20 May 2019 08:13:13 GMT

Many makros won't be executed on the server-side. There are a few execptions and AFAIK macro-functions belong to them and should work if macros are enabled within the server and the code didn't contain references to the ActiveDocument (didn't exists on this level whereby your code didn't include any) and ActiveX (here I'm not absolutely sure if it's possible - but if ActiveX must be enabled properly within the OS - and I think your used RegEx based on it). If any of the mentioned causes is true it will lead to an invalid function which may return an error-message like yours.

I think I would start with a simple test of a macro-function - maybe with a dummy app/data - which used a single replace() to change e to a. If it's worked you know that such macro-function worked in general and your issue is caused from the ActiveX part. To enable it might be difficult especially as it could violate any security rules in your company.

Your attempt to use the function within the UI won't work unless you enables the macro-functions within the easter egg whereby it's not recommended to change these settings.

As an alternatively you could try to implement your transformation with native Qlik functions. Quite useful for it is mapsubstring(). Here an example what is meant: Passing-parameter-strings-that-contain-special-characters

- Marcus

Re: Issue with stripHTML function in QlikView

Brett_Bleess — Wed, 26 Jun 2019 20:44:09 GMT

I have a hunch I know what the issue is, believe it should be that the QlikViewBatch Settings.ini is missing the following setting:

AllowMacroFunctionsInExpressions

That would need to have an =1 to be activated there. The setting will not be there, you will have to manually add it as follows within the [Settings 7] area:

AllowMacroFunctionsInExpressions=1

I believe that should get things working when you run it via Publisher/Reload Engine task. Hopefully this does the trick, I believe you should have had to have changed this in the client settings as well though, so I am a bit puzzled there! 🙂

Regards,
Brett

PS, helps if I remember to give you the path to the Settings.ini! 🙂 Sorry about that:

C:\Windows\System32\config\systemprofile\AppData\Roaming\QlikTech\QlikViewBatch\