Discussion Board for collaboration on QlikView Scripting.
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?
Go to Solution.
Press control M and make a macro with this code:
function RemoveHTML( strText )
Set RegEx = New RegExp
RegEx.Pattern = "<[^>]*>"
RegEx.Global = True
RemoveHTML = RegEx.Replace(strText, " ")
Here's an example:
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?