HTML tags while taking sharepoint data into Qlikview report

[vijetas42]

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.

[Anonymous]

Did you check this?

Removing HTML markup code

How to remove HTML tags in Qlikview

Hiding HTML tags displayed in report on Sharepoint list

[vijetas42]

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.

[settu_periasamy]

May try this..

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