topic Re: HTML tags while taking sharepoint data into Qlikview report in QlikView

HTML tags while taking sharepoint data into Qlikview report

vijetas42 — Mon, 01 Feb 2016 06:59:59 GMT

Hi all,

currently I am exporting sharepoint data into qlikview but' it's containing html tags in data values.can anybody help me for how to remove it

I found one code from Removing HTML markup code

HTMLTag_Map:

MAPPING LOAD Distinct '<' & TextBetween('<' & SubField([Decision Comments], '<', IterNo()), '<','>') & '>' as HTMLTag, '' as Substitute

Resident Decisions;

Join (Decisions) LOAD ID, MapSubString('HTMLTag_Map', [Decision Comments]) as [Decision Comments Cleansed]

Resident Decisions;

while not ISNULL (SubField([Decision Comments], '<', IterNo()));

I tried this as well but still don't work.

Re: HTML tags while taking sharepoint data into Qlikview report

Anonymous — Mon, 01 Feb 2016 07:06:22 GMT

Did you check this?

Removing HTML markup code

How to remove HTML tags in Qlikview

Hiding HTML tags displayed in report on Sharepoint list

Re: HTML tags while taking sharepoint data into Qlikview report

vijetas42 — Mon, 01 Feb 2016 10:26:06 GMT

Hi all,

I have sorted with removing html mark ups and it's working fine but in between text &nbsp is coming e.g. my string is aaab&nbsp adgbvbhghd&nbsp&nbsp aursusd so from this text I want to remove all &nbsp thing.how can I achiece this.

Re: HTML tags while taking sharepoint data into Qlikview report

settu_periasamy — Mon, 01 Feb 2016 10:33:56 GMT

May try this..

Replace(MapSubString('HTMLTag_Map', [Decision Comments]),'&nbsp',' ') as [Decision Comments Cleansed]