Hi, I searched the forums with no success, hope someone can help me. I have a CSV from a feedback system, that gives me a CSV like this:
Field1; Field2; Field3; Field4;
Value1; Val2-1,Val2-2; Val3; Val4-1, Val4-2, Val4-3
Value1; Val2-1; Val3-1, Val3-2; Val4-1, Val4-2, Val4-3
Basically:
FieldX are my headers, fixed.
The values are separated with ";" and inside each value may appear more than one value, separated by ",".
In the first line of the example, Field2 has two values and only one in the following line.
In the second row Field4 contains 3 values as in the first line.
I would like to obtain a structured data set, to be able to query/group for single values inside the fields:
{ "Field1": "Value1", "Field2": [ "Val2-1", "Val2-2"], "Field3": ... }
Think about F2 as Countries, F3 as Interests and so on. Multiple choices in the form.
Hope I was clear enough.
Thank you