Hitachi Vantara Pentaho Community Forums
Results 1 to 5 of 5

Thread: CSV Input ignoring Enclosure character

  1. #1
    Join Date
    Oct 2007
    Posts
    4

    Default CSV Input ignoring Enclosure character

    Hi everyone,

    When Kettle reads a CSV file with with enclosure (escape character) quote (") it includes the quotes in the field names, and in the data, which is quite annoying

    For example with this file one would end up with all the quotes in Kettle:

    "id","name","value"
    12,"hello world",123


    Best regard,
    Jóan Petur

  2. #2
    Join Date
    Jul 2007
    Posts
    1,013

  3. #3
    Join Date
    Oct 2007
    Posts
    4

    Default

    Great! Thank you. It works with those jar files provided there. However there is still a problem if delimiter characters are inside enclosures,e.g. if a comma is inside a pair of qoutes, it will still be interpreted as a delimiter.

    Quote Originally Posted by tdidomenico View Post

  4. #4
    Join Date
    Nov 1999
    Posts
    9,729

    Default

    There are bug reports open for that one. We should be able to fix those before 3.0 hits the ground.

  5. #5
    Join Date
    Nov 1999
    Posts
    9,729

    Default

    Should be fixed in the upcoming 3.0.0-RC2.

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.