How to split and fold while escaping the comma in strings

Edli

I have the same task as the person in the dataiku discussion linked below. I'm using Sarina's solution at the bottom of that page. However, since some of the strings in my arrays have ", " (comma space) as part of the string, I can't use ", " as a separator, otherwise the array will split in the middle of a string. I couldn't find a processor that would allow me to escape the ", " in strings, but still split between elements of the array.

How do I best do this?

Here is the other post I'm talking about:

json data manipulation — Dataiku Community

Operating system used: Windows 11

Alexandru

Hi,
Could you please share an example of one of the arrays you want to split and the desired end result?

Thanks