How to get content from Div Html Element

[marcel_olmo]

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.

[cwolf · Accepted solution]

you can load it like xml:

LOAD

li%Table as Value

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

- Christian

[marcel_olmo]

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

Regards, Marcel.