Aqwa data export to CSV problem

- November 22, 2017 at 2:14 pm
  
  danirizziero
  Subscriber
  
  Hi there! I'm doing a lot of simulations with Aqwa and I've a problem exporting data (in order to do diagrams). The problem is that the CSV file produced by Aqwa uses ',' as separator between the values. These values are not integer numbers!! So when I try to open the CSV file with Excel or similar the result is messed up (please see example below), because the integer part and the fractional part of each number are divided into 2 different data entries in the XLSX Excel file.
  
  [Example]
  
  Original Data Entries:
  
  12,234
  84938
  65,98
  ...
  
  CSV FILE:
  
  ...
  12,234,84938,65,98...
  
  Is there any way to make Aqwa use a different separator between the values? I think that might solve the problem.
  
  Thanks in advance!!
  
  Daniele
- November 1, 2018 at 2:23 pm
  
  CarlReiner
  Subscriber
  
  Altough I am certainly too late to help you, Daniele, I think the following might help others with the same problem:
  
  I had this issue too and solved it by simply changing my system language (Windows 10) from German to English. Since that, all decimal separators in the CSV-files are denoted as '.' instead of ','.
  
  Hope this is helpful.
  
  Cheers,
  
  Carl
- September 23, 2021 at 12:55 am
  
  Jezza
  Subscriber
  
  .
  Another much too late response, but could help someone in the future. If you are running Aqwa from Workbench, you can specify the seperator value for csv files. Select project, change export CSV Seperator Definition to Manual Definition and choose a value. See the image below.
  Hope this helps someone out.
  
  .