How to find a regex in re2 to search between strings?
<p>I need to extract in RE2 syntax for Google sheets a query like below. The problems is i have to have everything between (including punctuation and amount of words) <strong>"name":"</strong> and <strong>"},</strong></p>

<p><strong>NOTE: This is only one cell, there are many like this in my spreadsheet</strong></p>

<pre><code>interests":[
{"id":"1","name":"West Bromwich Albion F.C."}, 
{"id":"2","name":"Tottenham Hotspur F.C."},
{"id":"3","name":"Arsenal F.C."},
{"id":"4","name":"Liverpool F.C."},
{"id":"5","name":"Sunderland A.F.C."},
{"id":"6","name":"EPL"},    
{"id":"7","name":"Southampton F.C."},
{"id":"8","name":"Manchester United F.C."},
{"id":"9","name":"A-League"},
{"id":"10","name":"West Ham United F.C."},
{"id":"11","name":"Chelsea F.C."},
{"id":"12","name":"Burnley Football Club"},
{"id":"13","name":"Barclays English Premiership"},
{"id":"14","name":"Stoke City F.C."},
{"id":"15","name":"Arsenal"},
{"id":"16","name":"Crystal Palace F.C."},
{"id":"17","name":"Football"},
{"id":"18","name":"Aston Villa F.C."},
{"id":"19","name":"Norwich City F.C."},
{"id":"20","name":"Leicester City F.C."},
{"id":"21","name":"Everton F.C."},
{"id":"22","name":"Arsenal Fans"},
{"id":"23","name":"Manchester City F.C."}]}],
</code></pre>

<p>my formula is </p>

<pre><code>=iferror(REGEXEXTRACT(K98, "name\W:\W(.*?)\W}"), "")
</code></pre>

<p>but it returns only one in the column I need all the name of the football clubs in the same column or seperate.</p>

<p>i also tried using</p>

<pre><code>=regexreplace(K98,"^interests\W+id\W\W+\w+\W+name\W:\W(.*?)\W},\W+id\W\W+\w+\W+name\W:\W(.*?)\W},\W+id\W\W+\w+\W+name\W:\W(.*?)\W}]}],$","$1, $2, $3")
</code></pre>

<p>to place in in the same column but returns the below (example)</p>

<pre><code>interests":[{"id":"1","name":"Movies"},{"id":"2","name":"Entertainment"}]}],
</code></pre>

<p>b) when it cant find, so i put a regexmatch for each case but the (.<em>?) still reads the case &lt;- how do i deal with the (.</em>?)</p>