Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Semi colon (;) separated CSV ouput?

  1. #1

    Default Semi colon (;) separated CSV ouput?

    Hi Guys,

    I came across very weird situation here.

    When I am passing 'outputType=csv' to CDA url then I am getting csv in semicolon separated ";" format, not in comma separated format (,).

    Did anyone faced this issue before?

    Thanks in advance for solution.

    Thanks,
    Vishwesh

  2. #2
    Join Date
    Jul 2007
    Posts
    2,498

    Default

    Add &settingscsvSeparator=, (I think its this)
    Pedro Alves
    Meet us on ##pentaho, a FreeNode irc channel

  3. #3

    Default

    Quote Originally Posted by pmalves View Post
    Add &settingscsvSeparator=, (I think its this)
    I am trying it like below:
    cdaUri = "/pentaho/content/cda/doQuery?path=xxx_tools/resources/test_file.cda";
    cdaUri += "&dataAccessId=1"
    cdaUri += "&paramReportDate=" + rptDate;
    cdaUri += "&outputType=csv"
    cdaUri += "&settingscsvSeparator=,";


    Am I doing something wrong here??

    Thanks.

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.