In Snowflake, how do I parse an array? I would like to separate the array whenever this sequence “”, occurs within it.
Below is my array.
[
"JOE_SMITH 14:29:02",
" CHANGEDBY: JANE_DOE -> JOE_SMITH",
" CHANGEDATE: 2/21/2024 -> 2/24/2024",
"",
"JOE_SMITH 14:29:02",
" OPENORDER: TRUE -> FALSE"
]
Below is what I tried and it didn’t work:
SPLIT(Array)
Below is what I’m expecting. Parse the data into multiple arrays or varchar strings is fine for me.
[
"JOE_SMITH 14:29:02",
" CHANGEDBY: JANE_DOE -> JOE_SMITH",
" CHANGEDATE: 2/21/2024 -> 2/24/2024",]
[
"JOE_SMITH 14:29:02",
" OPENORDER: TRUE -> FALSE"
]
New contributor
HoosierDuckling is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.