Seperate scraped values by delimiter ","

Support
#1

If I use an xpath, which gives me back more than one result, but I don't want to display it in more than one column, can I seperate it with some delimiter?

XPathOnUrl(...)
-> Text 1 Text 2 Text 3 Text 4

Dump(XPathonUrl(...)
Text 1
Text 2
Text 3
Text 4

My requirement
Text1, Text2, Text3, Text4

#2

Yes, you can use StringJoin. The following separates the items by comma:

=StringJoin(XPathOnUrl(A1,"XPath"),",")

In the example below, I used Dump to generate the items in column A, then changed to Stringjoin to concatenate the original array, separated by comma.

bild.png1573×761 51.7 KB

#3

Ah, perfect! Didn't know that! Thank you very much @diskborste