How to get content from Div Html Element

marcel_olmo — Fri, 26 Oct 2018 15:04:37 GMT

Hi guys,

I have an input field like this :

'<div class="details-two"><div class="details-two addon"> <ul> <li> DesiredValue1 </li> </ul> </div> <div class="details-two addon"> <ul> <li> DesiredValue2 </li> </ul> </div> </div>'

And I'd like to get this desired result :

Field

DesiredValue1

DesiredValue2

DesiredValue3

I'm trying to use the function textbetween (using the div element as separator), or subfield( using the li element as separator, because it's the closest one to the desiredvalue string), but I have the following results :

How would you do that? I've attached my sample to get the point.

PD : I made my example as simple as I can, but in my real example there's a bunch of desired values to pick up, all of them contained in <li> tags.

Regards, Marcel.

Re: How to get content from Div Html Element

cwolf — Fri, 26 Oct 2018 15:29:26 GMT

you can load it like xml:

LOAD

li%Table as Value

From_Field('DivExample','DivExampleField') (XmlSimple, Table is [div/div/ul/li]);

- Christian

Re: How to get content from Div Html Element

marcel_olmo — Fri, 26 Oct 2018 15:35:29 GMT

Thanks Christian! I didn't even know that function existed. It's just what I wanted.

Regards, Marcel.

topic How to get content from Div Html Element in QlikView

How to get content from Div Html Element

Re: How to get content from Div Html Element

Re: How to get content from Div Html Element