Actors in a single line and comma

How to?
#1

Describe the problem.

Hi im totally a nooobi onto scraping but id like to ask ou how to do this, i want the actors name in a single line and a comma after each name

Example James Marsden. Tom Wachowski. Jim Carrey

Url: https://www.themoviedb.org/movie/454626-sonic-the-hedgehog

Sitemap:
{{"_id":"kkk","startUrl":["https://www.themoviedb.org/movie/454626-sonic-the-hedgehog"],"selectors":[{"id":"okok","type":"SelectorText","parentSelectors":["_root"],"selector":".card p a","multiple":true,"regex":"","delay":0}]}}

#2

Type: Grouped is probably your best option, but you'll need to do post-processing to change the unwanted bits to commas. The text patterns are consistent though:

{"_id":"forum-themoviedb","startUrl":["https://www.themoviedb.org/movie/454626-sonic-the-hedgehog"],"selectors":[{"id":"Movie","type":"SelectorText","parentSelectors":["_root"],"selector":"div.title h2","multiple":false,"regex":"","delay":0},{"id":"Cast","type":"SelectorGroup","parentSelectors":["_root"],"selector":".card p a","delay":0,"extractAttribute":"a"}]}

The scraped data from Grouped is in a single line JSON format which looks like this:

[{"Cast":"Ben Schwartz","Cast-a":""},{"Cast":"James Marsden","Cast-a":""},{"Cast":"Jim Carrey","Cast-a":""},{"Cast":"Tika Sumpter","Cast-a":""},{"Cast":"Lee Majdoub","Cast-a":""}]

#3

Thanyou leemeng
and lets say i scraped 100 articles.

i will get the json thing. but how i decode the json to obtain the result actor1, actor2, actor 3?

#4

For a long-term solution you would need a script or program to extract data from the Json.

For a quick solution, you could just manually search n replace the unwanted bits,e.g.

Unwanted bits between actors
","Cast-a":""},{"Cast":" replace with ,

Unwanted bit at beginning:
[{"Cast":" replace with "

Unwanted bit at end:
","Cast-a":""}] replace with "

This should result in:
"Ben Schwartz,James Marsden,Jim Carrey,etc,etc"