topic Re: Column that contains HTML in QlikView

Column that contains HTML

Tue, 10 Dec 2013 14:16:33 GMT

Hello,

is it possible to eliminate the html-tags from a column that contains following values:

<html><body> test: draft </body></html>

I want that only test and draft is being showed in the column after removing the tags.

Thanks for your help!

Best regards,

Aylin

Re: Column that contains HTML

rbecher — Tue, 10 Dec 2013 14:48:46 GMT

Hi,

this is an example how to strip HTML tags:

Data:
LOAD RecNo() as RecNo, Field
FROM <your source file>;

HtmlTag_Map:
MAPPING LOAD DISTINCT '<' & TextBetween('<' & SubField(Field, '<', IterNo()),'<','>') & '>' as HtmlTag, '' as Substitute
Resident Data
While NOT IsNull(SubField(Field, '<', IterNo()));

JOIN(Data) LOAD RecNo, MapSubstring('HtmlTag_Map', Field) as Field_Cleansed
Resident Data;

It looks a bit complex but it's easy to adapt. There are three steps:

1. Load the field with HTML tags

2. Create a Mapping Table containing all in data existing HTML tags

3. Use MapSunstring to replace the existing HTML tags with empty string

- Ralf

PS: this example is also released on my GiiHub/Gist account

Re: Column that contains HTML

rbecher — Tue, 10 Dec 2013 14:54:31 GMT

In addition, I recognized some spaces between tags in your example: _  and _

To get rid of this it should be fixed before with a replace like this: replace(Field, '> <', '><')