'SQL regex extract similar pattern text

I am using SQL in redshift. So here is what I have:

A header	Another header
text	[{"name":"alex","country":"france","name":"mike","country":"usa","name":"Jake", "country":"italy"}]

I would like to extract all the names from the text into one column:

A header	Another header
First	alex,mike,jake

Solution 1:^[1]

try to use this regex (?:"name":")\w+

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Solution	Source
Solution 1