Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Change CDE Export CSV Change Separator

  1. #1
    Join Date
    Jan 2013
    Posts
    18

    Default Change CDE Export CSV Change Separator

    Is it possible to change the CSV separator character from the default ";" to a ","?

    I've found a file - "system/cda/cda.properties" but changing it here doesn't seem to have an effect. Is there somewhere else I can change?

    Also is is possible to set the formatting for columns when exporting to an xls file? I'm exporting (in my file) the number "123456" but when I open the file it appears as "123,456.00".

    Thanks!

  2. #2
    Join Date
    Nov 2011
    Posts
    1,229

    Default

    No, that's the proper way of changing the separator. What cda version are you using ?

    As for formatting the columns in excel, you can define and use a template xls file. Configure its columns as you wish and that's it. Otherwise, you'll get the default excel formats for the data types.
    Pedro Vale
    --
    CTools Product Development
    http://www.webdetails.pt

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.