😁😄😂

Ask|Read Value From Json Data

I want to read values of JSON data using Regex such as "name", "street", "lat" and "lon".
This is my pattern, but it's still not work..

https://regex101.com/r/MfvgEr/1

Why don't you use direct access to properties?

😂

because I was only given raw data like that, for clarity it's in the stack overflow.

https://stackoverflow.com/questions/65314159/parse-json-using-regex-in-google-sheet

Like what?

raw json data

WHere do you have it?

engineer.., they not able to share token key to access it, so i was only given json data as raw..

By the way  (keyowrd|keyword):([\s\d\w]+) . But prefferable try to work with json data and get props

What do you mean you should have more?

Except raw json data

row data



{ 
"uuid": "1", 
"result": [ 
{ 
"place_info": { 
"name":"place 1", 
"street":"road 1" 
}, 
"location": { 
"lat":"1", 
"lon":"0" 
}, 
"city":"jkt", 
"country":"id" 
}, 
{ 
"place_info": { 
"name":"place 2", 
"street":"road 2" 
}, 
"location": { 
"lat":"1", 
"lon":"0" 
}, 
"city":"jkt", 
"country":"id" 
}, 
{ 
"place_info": { 
"name":"place 3", 
"street":"road 3" 
}, 
"location": { 
"lat":"1", 
"lon":"0" 
}, 
"city":"jkt", 
"country":"id" 
} 

is not it possible to read value from json data using regex?

i think i need use script to extract value from json data. thanks before..

If you would need fire you can take a wood stick and get fire from friction

It is possible