Share
Report
117Hi everybody
I'm using the JSON function to transpose my columns to rows:
Set(
varJson2,
Split(
Substitute(
Substitute(
Substitute(
Substitute(
Substitute(
JSON(
colOne,
JSONFormat.Compact
),
"[",
""
),
"{",
""
),
"}",
""
),
"]",
""
),
Char(34),
""
),
","
)
);
It works great in edit mode but in play mode it only returns my guid values.
Before anybody asks, I've tried all the JSON formats available (compact, indentfour, includebinarydata, ignorebinarydata, ignoreunsupportedtypes)
Can anybody help me with this problem?
Best regards
Eva
Categories:
I have the same question (0)
All responses (
Answers (
