topic How to remove HTML tags in Qlikview in QlikView

How to remove HTML tags in Qlikview

vinod2086 — Tue, 28 Oct 2014 06:30:34 GMT

Hi friends am facing one issue not understanding how to resolve

the thing is we are extracting data from share point every thing is fine but some fields contains HTML tags please fing attached file for clear information please help me out.

need very urgent

Thanks in Advance

Regards,

Vinod

Re: How to remove HTML tags in Qlikview

Tue, 28 Oct 2014 06:38:39 GMT

Check:

Removing HTML markup code

Thanks,

Singh

Re: How to remove HTML tags in Qlikview

vinod2086 — Tue, 28 Oct 2014 06:56:08 GMT

Hi Angad Singh,

Thanks for your reply but the thing is in my Extractor i applied below logic

subfield(subfield((ows_Desc),'<div>',2),'</div>',1) as [Description]

subfield(subfield((ows_Impact),'<p>',2),'</p>',1) as Impact,

subfield(subfield((ows_Cause),'<div>',2),'</div>',1) as [Cause],

subfield(subfield((ows_Action),'<div>',2),'</div,>',1) as [Action],

subfield(subfield((ows_mplication),'<div>',2),'</div>',1) as [ Implication],

subfield(subfield((ows_Evidence),'<div>',2),'</div>',1)as Evidence]

after that values are coming like my attachment file is there any other way to remove all HTML tags at a time?

Re: How to remove HTML tags in Qlikview

CELAMBARASAN — Tue, 28 Oct 2014 07:46:38 GMT

You can do it with the help of VB script regular expression

Add the below function in Macro

Function RegExReplace(iString, sPattern, rPattern)

' Replaces any occurence of sPattern within the string iString with rPattern

' and returns the modified string, if no match is found the original string

' is returned

' iString: string, the input string to search and replace in

' sPattern: string, the pattern to search for

' rPattern: string, the pattern to replace the found pattern with

set RE = New RegExp

RE.Pattern = sPattern

RE.Global = True

RegExReplace = RE.Replace(iString, rPattern)

End Function

Use Load Statement as something like below

LOAD

RegExReplace(Description, '\<.*\>', '') AS Description

....

From Source;

Re: How to remove HTML tags in Qlikview

Tue, 28 Oct 2014 07:51:14 GMT

You can actually create a mapping table and replace the fields with ''. I found the html special character list here:

degraeve.com/reference/specialcharacters.php

use this as Mapping Table and further clean your code.

Hope this was helpful.

Thanks,

Singh