So, I have this data

{"ABC":"Hello"},{"DEF":"World"},{"GHI":"!!!"}

How to make a regex to generate a string inside brackets that contains ABC so it will return Hello?

I also want to generate a string inside brackets that contains GHI so it will return !!!

I will be using this in JavaScript, Python, and REGEXP_EXTRACT function in SQL.

Currently I am trying to do this

{"DEF":"(.*?)"}

But the result is

{"ABC":"Hello"},World,{"GHI":"!!!"}

I got the solution

I should add .* in before and after my regex

so

.*{"ABC":"(.*?)"}.*

will result Hello