pastvne
Bruce Decker
Fabrik 3.2 on Joomla 3.3
I have a export to csv on a list.
The params for the export specific 'Excel CSV" as the format
The file comes in with semi-colon rather than comma delimiters between columns
I don't see a place in the properties to modify the delimiter that is used
Apparently this is a pretty common issue aside from Fabrik and many regions, especially in Europe, use semi-colon as the column delimiter. However, when running in USA region, Excel balks at the semi-colon and when opening the csv it tosses the entire line into column 1 with all quotes and delimiters.
My temp work around is to:
1) Rename the csv as .txt
2) Open excel
3) Open the .txt file
4) Click 'semi-colon delimiter' in the conversion wizard
But users, of course, are complaining that this is too complicated.
Is there an option I'm not finding to set the delimiter that is used?
I can probably find and hack it into the code but would prefer to see a param on the excel export that allows for specification of the formatting sauce going into the spreadsheet.
Thanks,
BD
I have a export to csv on a list.
The params for the export specific 'Excel CSV" as the format
The file comes in with semi-colon rather than comma delimiters between columns
I don't see a place in the properties to modify the delimiter that is used
Apparently this is a pretty common issue aside from Fabrik and many regions, especially in Europe, use semi-colon as the column delimiter. However, when running in USA region, Excel balks at the semi-colon and when opening the csv it tosses the entire line into column 1 with all quotes and delimiters.
My temp work around is to:
1) Rename the csv as .txt
2) Open excel
3) Open the .txt file
4) Click 'semi-colon delimiter' in the conversion wizard
But users, of course, are complaining that this is too complicated.
Is there an option I'm not finding to set the delimiter that is used?
I can probably find and hack it into the code but would prefer to see a param on the excel export that allows for specification of the formatting sauce going into the spreadsheet.
Thanks,
BD