Excel Export - changing the delimiter
We are experiencing difficulties as the excel export automatically uses a 'comma' as a delimiter and this causes some data to break into incorrect columns from our Finance system.
Is it possible to change this to a 'semi colon' to avoid this?
-
Hi M Shaw,
Below is a small plugin that allows you to change the delimiter for export to .csv. You could use this plugin to change the delimiter from the comma to the semi colon.
Unzip the plugin then place the plugin in your plugins directory. Then edit the ChangeCSVSeparator.js file and modify line 5 to the desired delimiter character.
Hope this solves the issue you're facing!
Please sign in to leave a comment.
Comments
1 comment