Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi all,
I have sorted with removing html mark ups and it's working fine but in between text   is coming e.g. my string is aaab  adgbvbhghd   aursusd so from this text I want to remove all   thing.how can I achiece this.
May try this..
Replace(MapSubString('HTMLTag_Map', [Decision Comments]),' ',' ') as [Decision Comments Cleansed]