Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
nickedw0
Creator
Creator

html tags embedded in xml data load.

When I load a list from SharePoint using iwssvr.dll I get httml tags embedded in the data. An example is:

<div class="ExternalClass689BA2FF7E5245C7B41C2E552300FC30"><html>   <p>​19099</p><p><span aria-hidden="true" id="ms-rterangepaste-start"></span>23324<span aria-hidden="true" id="ms-rterangepaste-end"></span></p>   <p>&#160;</p> </html></div>

The load statement looks like this

Load ows_ID AS ID,

ows_Exception_x0020_ID as [Exception]

FROM [https://sp.....(xmlSimple, utf8,Table is [xml]);

Is there a way for Qlikview to ignore the html?

 

2 Replies
nickedw0
Creator
Creator
Author

should have said owssvr.dll

Brett_Bleess
Former Employee
Former Employee

The only thing that comes to mind is the Transform option in the data load wizard....

https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/File_Wizard_Tra...

Hopefully this may do the trick.

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.