Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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> </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?
should have said owssvr.dll
The only thing that comes to mind is the Transform option in the data load wizard....
Hopefully this may do the trick.
Regards,
Brett