Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: Enclosure problem in input text file (sample join)

  1. #1
    Join Date
    Sep 2005
    Posts
    1,403

    Default Enclosure problem in input text file (sample join)

    Attachment: SATtxtExtCPT_prim.csv Hi and thanks for your great job!
    The file I join don't work well in the Text File Input.
    The separator is , and the enclosure is " for the string values.
    When I call previex rows, the rows TYPFAC is looking like: 2", in should be 2!
    And then, the rest of the data are a little bit corrupted (see col :CODACNFAC): N",",",",",",
    Is it a bug ?

  2. #2
    Join Date
    Sep 2005
    Posts
    1,403

    Default RE: Enclosure problem in input text file (sample join)

    Hi,


    we just tested a text file and found there is a bug when the field has only one character between the enclosures like "2".
    Cheers - Jens

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

    Default RE: Enclosure problem in input text file (sample join)

    Hi,

    I made a fix for this, please check tracker:
    Bug - [# 1502] Enclosure problem in input text file ("a" parsed incorrectly)

    Get the latest kettle.jar for a quick solution.

    Kind regards,

    Matt

  4. #4
    Join Date
    Sep 2005
    Posts
    1,403

    Default RE: Enclosure problem in input text file (sample join)

    It's working.
    Thanks a lot!

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.