Split the Address field in JSON


#1

Hi Geeks,
Want to split the below Address Field in MS Access, which is coming in JSON.
needs to be split the Address field (below) into multiple fields, Ideas Please

Address
"[
{
"“street”": ““678 Willedrobe Dr.””,
"“state”": ““IL””,
"“zipcode”": ““34567"”,
”“city”": ““Indiana””
}
]"


#2

Hi @Rosana66,

What specifically are you asking for ideas on?