topic Re: HTML Tags in App Development

HTML Tags

SAITEJA — Tue, 12 May 2020 09:01:05 GMT

Hello,

I have qvd file in which one field consists various html tags how to remove them so that we can clean data

Re: HTML Tags

raji6763 — Wed, 13 May 2020 08:04:07 GMT

hi SAITEJA,

you can remove the field from Qvd file.

try this:

LOAD * FROM YourQvd.qvd (qvd);

DROP FIELD HtmltagField;

regards,

raji

Re: HTML Tags

SAITEJA — Wed, 13 May 2020 08:22:53 GMT

Can we do in this manner

Load

Field

From qvd:

Drop Htmltag field

Or else you want me to create Htmltag field or how I am confused here

Re: HTML Tags

raji6763 — Wed, 13 May 2020 10:46:45 GMT

if you confused, comment the html tag field when store as a QVD.

Re: HTML Tags

SAITEJA — Wed, 13 May 2020 18:05:03 GMT

Actually I want to clear the all the html tags in a table tried using Mapsubstring shows the error larger amount data,so what can be the alternative so that there will less data load time?

Re: HTML Tags

QlikTom — Wed, 13 May 2020 18:46:08 GMT

Hello, take a look at this solution, which will remove standard tags like <a href></a> and translate HTML entities to their proper form.

https://community.qlik.com/t5/New-to-Qlik-Sense/Deleting-text-between-characters/m-p/1685803#M160422

Unfortunately, I am not familiar with the "larger amount data" error.

Re: HTML Tags

SAITEJA — Wed, 13 May 2020 18:55:44 GMT

Thank you, I will try it and let you know😀

Re: HTML Tags

SAITEJA — Thu, 14 May 2020 09:55:18 GMT

Hello,

I have tried the code but got the general description error.

Re: HTML Tags

QlikTom — Thu, 14 May 2020 12:38:04 GMT

I am not familiar with the "general description error"

This forum will actually allow you to upload screenshots and sample data files.

I would say the best hope for a solution would be to upload a sample of the data that you are working with (or an artificial version with the same basic properties) in excel or CSV. This way community members can verify proposed solutions work.

Re: HTML Tags

SAITEJA — Fri, 15 May 2020 08:42:58 GMT

I have attached the excel of similar kind of data where field different type of data

Re: HTML Tags

QlikTom — Tue, 02 Jun 2020 14:49:34 GMT

Sorry for the delay, I just now was able to get back to the community.

I took your sample data and used this script:
*I stripped out carriage returns, and replaced them with a space character, otherwise the data will not render in a table.
simply remove the replace function if you want to maintain them and have other plans for displace.

If you are receiving any kind of error server, I recommend you contact support and they should be able to diagnose the issue.

SampleData_Temp: LOAD "Field", ID FROM [lib://DataFolder/ExcelData/Community/comm71215.xls] (biff, embedded labels, table is Sheet1$); //load all possible HTML tags that exist in field, set replacement as '' TagMap_Temp: LOAD DISTINCT '<' & TextBetween('<' & SubField("Field", '<'),'<','>') & '>' as TagMatch , '' as Replacement Resident SampleData_Temp; //concatenate hand type html entities into temp table (This would happen automatically without concatinate syntax) //This inline table can be used to replace any HTML entities with their unicode counterpart if required. Concatenate (TagMap_Temp) LOAD * INLINE [ TagMatch, Replacement ':', ':' ]; //create a mapping table of all potential tags, and their replacements from the temp table TagMap: MAPPING LOAD * Resident TagMap_Temp; //drop TagMap_Temp, as it is no longer needed Drop Table TagMap_Temp; //NoConcatenate prevents automatic contatination with source table NoConcatenate //use MapSubString Funciton to remove all possible tags FinalResult: load Replace(MapSubString('TagMap',"Field"), Chr(10), ' ') as "Field", ID resident SampleData_Temp; drop table SampleData_Temp;

Data load progress

Result in a table.

Re: HTML Tags

SAITEJA — Thu, 04 Jun 2020 17:20:59 GMT

Thanks a lot 😊

Re: HTML Tags

Felipe_Violin — Mon, 06 Feb 2023 18:14:19 GMT

Congratulations.
Worked perfectly.

Thanks
Just a complement in mysql I needed to use another function in sql before to work.

https://stackoverflow.com/questions/3678980/is-there-a-mysql-function-to-decode-html-entities

Re: HTML Tags

Fran_by — Wed, 09 Oct 2024 09:17:04 GMT

Cool solution!