How to do Regular Expressions in JavaScript, Python, and SQL with multiple brackets and generate string from brackets that contains specific character

Question

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

In which programming language or regexp library? Why specifically regular expressions? Can the string contain escapes like `\"`? — Arkku, Dec 06 '21 at 11:41
@Arkku, I am using this in JavaScript, Python, and REGEXP_EXTRACT function in SQL, basically needs 3 of them — Furqon Aji Yudhistira, Dec 06 '21 at 12:04
Ok, I suggest editing the question to contain this information, and preferably also your attempts at doing it. — Arkku, Dec 06 '21 at 12:05
@Arkku, my bad, I add the question and my attempts, already got the the answer, thanks! — Furqon Aji Yudhistira, Dec 07 '21 at 00:29

score -1 · Answer 1 · answered Dec 06 '21 at 12:19

-1

Made an example on your line. Something like this looks like a regular: .*({\"ABC\":\".*?\"}).* screen

answered Dec 06 '21 at 12:19

Denis Kokorev

Hei, thanks!! I modified your regex into `.*{"DEF":"(.*?)"}.*` and result `World` – Furqon Aji Yudhistira Dec 07 '21 at 00:28
OK. I'm glad I helped. At first there was no explanation. I thought you needed the whole thing in {...}. – Denis Kokorev Dec 07 '21 at 13:01

1 Answers1