CODEWITHSUNDEEP
javascriptpythonregexmysql-regexp
Furqon Aji Yudhistira
Furqon Aji Yudhistira

Reputation: 21

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

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

Upvotes: -2

Views: 91

Answers (1)

Denis Kokorev
Denis Kokorev

Reputation: 25

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

Upvotes: -1

Related Questions