bggann
Active Member
I have a dropdown element for which multiple select is allowed.
If I do CSV export of that list, the data in that element is exported in a form that makes parsing it difficult.
For instance.
If my dropdown has the choices.
- Choice One
- Choice Two
- Choice Three
and I select "Choice One" and "Choice Three"
then the CSV export combines these into one feild
"Choice One Choice Three"
There is no delimiter in there so it is very hard to parse the field.
If I choose to Include Raw Data then the field is exported as
["Choice One","Choice Three"]
so I could potentially parse that - but then I get all the raw data, which I don't want.
Any way to get this to export with a delimiter of some sort?
- bob
If I do CSV export of that list, the data in that element is exported in a form that makes parsing it difficult.
For instance.
If my dropdown has the choices.
- Choice One
- Choice Two
- Choice Three
and I select "Choice One" and "Choice Three"
then the CSV export combines these into one feild
"Choice One Choice Three"
There is no delimiter in there so it is very hard to parse the field.
If I choose to Include Raw Data then the field is exported as
["Choice One","Choice Three"]
so I could potentially parse that - but then I get all the raw data, which I don't want.
Any way to get this to export with a delimiter of some sort?
- bob