Hi guys,
I'm trying to get paragraph content of some webpage with xpathonurl and it's working fine.
But the content being quite big, the result is returned in multiple vertical cells...
And i really need to get it into a single and unique cell.
Any ideas ?
Thanks for help
S.
Can you provide the URL, the content you want to extract, and the formula you are using?
of course 
url : https://www.hit-air-france.fr/
xpath : =Dump(XPathOnUrl("https://www.hit-air-France.fr";"//p"))
what i need to retrieve is the text content of the whole page in a single cell, so paragraph might be my best shot.
Same for nav menu content for example
=Dump(XPathOnUrl("https://www.hit-air-France.fr";"//ul/li[*]/a/span")
I get the content but in multiple vertical cells instead of one single cell.
I tried this =XPathOnUrl(url,"//*") but didn't manage to extract the text without code. So I used a cheat service (Boilerpipe) that made the hard work for me.
I extracted the text from the generated Url from Boilerpipe:
https://boilerpipe-web.appspot.com/extract?url=https%3A%2F%2Fwww.hit-air-france.fr%2F&extractor=DefaultExtractor&output=text&extractImages=&token=
With the following Xpath: =XPathOnUrl(A1;"//text()")
where A1 is where the aforementioned url is located.
Even easier would be to get the new url with the =concatenate function:
=concatenate("https://boilerpipe-web.appspot.com/extract?url=";[[URL-cell]];"%2F&extractor=DefaultExtractor&output=text&extractImages=&token=")
thanks a lot for help disk !
but the boilerpipe option adds and extra step that makes Niels's awesome tool less relevant.
Niels ? any idea to avoid the multiple vertical cells effect ?
great idea thanks niels !
one last thing : is there a way to add delimitation space between results in the xpathonurl function ?