Separate XPathOnUrl data values

#1

Hi,

Im trying to grab all of the text from a description box on a website using the XPathOnUrl function.

I am using "attribute::*" at the end of my XPath, which grabs all of the child text.

A snippet of the code:

        <h4>LP</h4>
     
		<ol>


        <li> Norman fucking Rockwell </li> 
	
		<li> Mariners Apartment Complex </li> 
	
		<li> Venice Bitch </li> 
	
		<li> Fuck it I love you </li> 
                    
        </ol>

I am currently getting the text as one long sentence. I would like it in a format, that keeps each line... on a new line within a single cell

My current sentence...
"LP Norman fucking Rockwell Venice Bitch Fuck it I love you"

My goal...
"LP
Norman fucking Rockwell
Venice Bitch
Fuck it I love you"

I have looked into both "StringJoin" and "Dump", and I cant get them to work in my favour. I think its because the data is coming from XPath as a single sort of sentence.

Any help is much appreciated.

#2

How about this? You were on the right track with StringJoin :slight_smile:

Also using Wrap Text to make the line breaks visible.