Excel Export - changing the delimiter

Follow

M Shaw

December 03, 2018 10:28

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?

 

0

• 

  Katie Garrison January 03, 2019 21:39

  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.

  ChangeCSVSeparator

  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!

  0

  Comment actions Permalink
• 

  Antonio Tomaro March 31, 2020 15:27

  Hi M Shaw, Hi Katie,

  thanks for this plugin.

  I installed it and it worked very good, I just have one question: would it be possible to set, in the ChangeCSVSeparator.js, the values rounding in order to round values to just the first two decimal places?

  Example as it is now: Field A, 9.204442 (Field B) -> Desired one: Field A, 9.20 (Field B)

  Best regards,

  Giuseppe

  0

  Comment actions Permalink

Please sign in to leave a comment.