Re: Getting the text from html code - Qlik Community

Report Inappropriate Content · ‎2012-08-02

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

swuehl · ‎2012-08-02

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,''))

)

Anonymous · ‎2012-08-02

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 ''.