topic RemoveHTML not working in QV API in QlikView

RemoveHTML not working in QV API

Mon, 02 Jul 2012 21:33:02 GMT

Hi community,

I have some QV code from a demo document and I tried to copy a portion of it to a document on my system. The code is RemoveHTML and it doesn't "turn blue" except for in the parent demo document. Any ideas why this is or what I can do?

Re: RemoveHTML not working in QV API

Tue, 03 Jul 2012 13:40:06 GMT

Here's an example:

load

RemoveHTML(TextBetween(TextBetween(YahooKeyStatsText, 'Market Cap (intraday)',''),'<td class="yfnc_tabledata1">','</td>')) as [Valuation: Market Cap - RAW],

RemoveHTML(TextBetween(TextBetween(YahooKeyStatsText, 'Enterprise Value',''),'<td class="yfnc_tabledata1">','</td>')) as [Valuation: Enterprise Value - RAW],

What might the document have different to allow this?

Re: RemoveHTML not working in QV API

Thu, 05 Jul 2012 14:13:32 GMT

Press control M and make a macro with this code:

function RemoveHTML( strText )

Dim RegEx

Set RegEx = New RegExp

RegEx.Pattern = "<[^>]*>"

RegEx.Global = True

RemoveHTML = RegEx.Replace(strText, " ")

End function