HI,
I have a query which has few temp columns that call one of my functions.
What the function does is, it takes a field value for example address field is passed into the function, and then I am using vba json parser to parse address field and then store appropriate value into the calling field. That means if temp column street calls the function, the address field gets parsed and street name gets picked and stored in the street column in query. So far so good. All the rest of the temp columns does the same. My problem is when address field contains multiple addresses, how do I insert a new row to the query results and create the second address along with the other columns.
The address field is in json format and can contain multiple addresses separated by comma.
It looks something like this:
Full Name county Address
John, doe Monroe "[
{
""where"": ""H"",
""street"": ""RD 1, Country Lane Road"",
""state"": ""PA"",
""zipcode"": ""16052"",
""city"": ""Prospect""
},
{
""where"": ""O"",
""street"": ""306 E. Water St."",
""state"": ""PA"",
""zipcode"": ""16057"",
""city"": ""Slippery Rock""
}
]"
Thanks for any help.
I have a query which has few temp columns that call one of my functions.
What the function does is, it takes a field value for example address field is passed into the function, and then I am using vba json parser to parse address field and then store appropriate value into the calling field. That means if temp column street calls the function, the address field gets parsed and street name gets picked and stored in the street column in query. So far so good. All the rest of the temp columns does the same. My problem is when address field contains multiple addresses, how do I insert a new row to the query results and create the second address along with the other columns.
The address field is in json format and can contain multiple addresses separated by comma.
It looks something like this:
Full Name county Address
John, doe Monroe "[
{
""where"": ""H"",
""street"": ""RD 1, Country Lane Road"",
""state"": ""PA"",
""zipcode"": ""16052"",
""city"": ""Prospect""
},
{
""where"": ""O"",
""street"": ""306 E. Water St."",
""state"": ""PA"",
""zipcode"": ""16057"",
""city"": ""Slippery Rock""
}
]"
Thanks for any help.