You’re offline. This is a read only version of the page.
19
Hey, I have this array of objects:
Share
Report[
{
"Name" : "Bob"
},
"Email" : "Bob@hotmail.com"
},
{
"DOB" : "19901025"
}
]
And I would like to convert it into one object:
[
{
"Name" : "Bob",
"Email" : "Bob@hotmail.com",
"DOB" : "19901025"
}
]
It would be a bonus if I can move this object out of the array since it will be the only entry, but any help is welcome. Thanks!
Hello @memorablename ,
I'd probably brute-force this. Convert the initial array with the object into string:
All responses (
Answers (
string(<yourInput>)replace },{ with only a comma:
replace(string(<yourInput>),'},{',',')turn it back into an array with an object:
json(replace(string(<yourInput>),'},{',','))get rid of the array and keep only the object (first value in the array)
first(json(replace(string(<yourInput>),'},{',',')))
#1
Michael E. Gernaey
497
Super User 2025 Season 1
#2
David_MA
436
Super User 2025 Season 1
#3
Riyaz_riz11
244
Super User 2025 Season 1
