CSV Export: split column value into multiple columns
we’re currently thinking about how to achieve the following task most efficiently (if possible at all):
When exporting a column set, split the values of a specific column (an ACF relation field, values separated by comma per default) into multiple columns in the resulting csv.
We’re aware that there are ways to achieve this in excel as well but the request was clearly that, if possible, do it directly on export.
I believe this involves some (maybe harder) logic to alter/parse the csv after all rows are processed because only then the amount of additional columns are known. Is there any way you could think of. Currently I’m only aware of this filter by which is not what would be needed here: https://www.admincolumns.com/documentation/filter-reference/acp-export-value/
It would involve adding a new column type, maybe?
Thanks for any hints on this.
You must be logged in to reply to this topic.