Scraping Amazon Sellers

diskborste 2018-02-07 12:20:41 UTC #21

Yes, I understand that. The formula I'm using only returns one email. You may have used the Dump() formula which returns several matches if exists.

Nosh 2018-02-07 14:29:42 UTC #22

Ahh yes. That´s right, thanks.
Sorry for the newbie questions

Nosh 2018-02-13 21:40:12 UTC #23

I saw that the fields are in different places on any profile.

Is is it possible to extract somehow the data after "Unternehmensvertreter:" and "Ustid:" (field names are always in bold)

diskborste 2018-02-14 07:50:06 UTC #24

I'm kind of hesitant to suggest these custom Xpaths given that they stopped working earlier. But anyway:

=XPathOnUrl(A1;"//span[@class='a-list-item'][descendant::span[contains(text(),'Unternehmensvertreter:')]]/text()")

=Dump(XPathOnUrl(A1;"//span[@class='a-list-item'][descendant::span[contains(text(),'UStID:')]]/text()"))

Nosh 2018-02-16 11:58:04 UTC #25

does not work, but thanks!

Nosh 2018-02-21 17:04:43 UTC #26

@dovydasm Maybe you have a solution for this one?
Thanks !

diskborste 2018-02-21 18:25:12 UTC #27

The invalid formulas was because of bad character formatting when pasting to from Excel. This one should work:

=Dump(XPathOnUrl(A1;"//span[@class='a-list-item'][descendant::span[contains(text(),'UStID:')]]/text()"))

Nosh 2018-02-21 19:59:05 UTC #28

Very nice ! Thanks !
Can you tell me why I cant get "Unternehmensvertreter" In this one? I guess it´s because its in a different place. But is there a simple solution?