topic Re: Getting the text from html code in QlikView

Getting the text from html code

Thu, 02 Aug 2012 08:09:16 GMT

Hi,

Is there any easier/best way to get the text from the html code.

I have the data in html code and need to fetch the data alone from that code.

Data will look like

<div class="ExternalClass124344545235"><body>Hi,Nice idea! Especially now, when there has been a lot of talk here about the quality of a product.It would be better if you release the model in the site...BR,Mathew</body></div>

I have to fetch the comment alone from this tag. Output should be Hi, Nice idea! Especially now, when there has been a lot of talk here about the quality of a product. It would be better if you release the model in the site...Mathew

Note: Based on the comments given, the number of and tag will vary

Re: Getting the text from html code

swuehl — Thu, 02 Aug 2012 09:15:19 GMT

I copied your text in a variable vText (could also be a field), then used:

=concat(

TextBetween(vText,'','',ValueLoop(1,SubStringCount(vText,'')))

,'',

ValueLoop(1,SubStringCount(vText,''))

)

Re: Getting the text from html code

Anonymous — Thu, 02 Aug 2012 09:20:40 GMT

Sounds messy, but I would do it like this:

=replace(replace(TextBetween('<div class="ExternalClass124344545235"><body>Hi,Nice idea! Especially now, when there has been a lot of talk here about the quality of a product.It would be better if you release the model in the site...BR,Mathew</body></div>','<body>','</body>'), '',''), '','')

So TextBetween() to pick everything between <body> and </body>. Then use Replace() to replace and with ''.