Exported data not in the same line

How to?
#1

Hey,
The scraper keep each data entry in a new line. What am I doing wrong?

image
image1208×168 10.9 KB

Url: https://sports.walla.co.il/

Sitemap:
{"_id":"sports_walla_co_il","startUrl":["https://sports.walla.co.il/"],"selectors":[{"id":"Date","parentSelectors":["Element Wrapper"],"type":"SelectorText","selector":"div.date","multiple":true,"regex":""},{"id":"Time","parentSelectors":["Element Wrapper"],"type":"SelectorText","selector":"div.time","multiple":true,"regex":""},{"id":"Channel","parentSelectors":["Element Wrapper"],"type":"SelectorText","selector":"div.chanel","multiple":true,"regex":""},{"id":"Logo","parentSelectors":["Element Wrapper"],"type":"SelectorImage","selector":".no-background img","multiple":true},{"id":"Description ","parentSelectors":["Element Wrapper"],"type":"SelectorText","selector":".txt div.title","multiple":true,"regex":""},{"id":"Notes","parentSelectors":["Element Wrapper"],"type":"SelectorText","selector":"li:nth-of-type(n+2) div.subtitle","multiple":true,"regex":""},{"id":"Element Wrapper","parentSelectors":["_root"],"type":"SelectorElement","selector":".broadcasts li","multiple":true}]}

1 Like
#2

@omernesh Hi, that's because most of the targeted elements are set to the 'Multiple' option which produces a unique row for each matched element.

In this case, you should use a single 'Element' selector set as a 'parent' with the 'multiple' option checked and all of the remaining selectors set as it's 'child' with the 'multiple' option not checked.

Alternatively, you can extract multiple paragraphs/images per single cell using the 'Grouped' selector.

Learn more:

Example:

{"_id":"sports_walla_co_il","startUrl":["https://sports.walla.co.il/"],"selectors":[{"id":"Date","multiple":false,"parentSelectors":["Element Wrapper"],"regex":"","selector":"div.date","type":"SelectorText"},{"id":"Time","multiple":false,"parentSelectors":["Element Wrapper"],"regex":"","selector":"div.time","type":"SelectorText"},{"id":"Channel","multiple":false,"parentSelectors":["Element Wrapper"],"regex":"","selector":"div.chanel","type":"SelectorText"},{"id":"Logo","multiple":false,"parentSelectors":["Element Wrapper"],"selector":".no-background img","type":"SelectorImage"},{"id":"Description ","multiple":false,"parentSelectors":["Element Wrapper"],"regex":"","selector":".txt div.title","type":"SelectorText"},{"id":"Notes","multiple":false,"parentSelectors":["Element Wrapper"],"regex":"","selector":"li:nth-of-type(n+2) div.subtitle","type":"SelectorText"},{"id":"Element Wrapper","multiple":true,"parentSelectors":["_root"],"selector":".broadcasts li","type":"SelectorElement"}]}

1 Like
#3

Thanks, that did the trick.