Hitachi Vantara Pentaho Community Forums
Results 1 to 7 of 7

Thread: Text input file issue

  1. #1
    Join Date
    Dec 2013
    Posts
    4

    Default Text input file issue

    I am trying to load data from text file input to db table with ',' separator and ' " ' enclosure . I have few fields like " keeny"s" when i was trying to load the data using text input file step the data is previewed as "keeny" and s get misplaced to next field instead of " Keeny"s" . I have so many different fields with extra " inside the filed . So help me to deal with this kind of data

  2. #2
    Join Date
    Apr 2008
    Posts
    1,771

    Default

    You should not have any problem if you use the comma as separator.
    ,Kenny"s, should be read as one field.
    Which version of PDI do you use?
    -- Mick --

  3. #3
    Join Date
    Dec 2013
    Posts
    4

    Default

    Quote Originally Posted by Mick_data View Post
    You should not have any problem if you use the comma as separator.
    ,Kenny"s, should be read as one field.
    Which version of PDI do you use?
    i use version 5

  4. #4
    Join Date
    Apr 2008
    Posts
    1,771

    Default

    Can you attach an example of your issue?
    Only few lines - one line with a correct row, another line showing your issue?
    And maybe a ktr file with your Text Input File step?
    -- Mick --

  5. #5
    Join Date
    Dec 2013
    Posts
    4

    Default

    Nnnn
    Last edited by sboyapati; 12-23-2013 at 12:43 PM.

  6. #6
    Join Date
    Apr 2008
    Posts
    1,771

    Default

    In my view, this is a bug.
    Can you create a case for it?
    http://jira.pentaho.com

    As a temp solution, I would load the file in memory and then do a search/replace of "," with another character, for example TAB.
    Then load your file using TAB as delimiter and NO enclosure.
    -- Mick --

  7. #7
    Join Date
    Dec 2013
    Posts
    4

    Default

    K 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.