Hitachi Vantara Pentaho Community Forums
Results 1 to 5 of 5

Thread: CVS input file using delimiter ; problem

  1. #1
    Join Date
    Apr 2008
    Posts
    6

    Default CVS input file using delimiter ; problem

    I want to read a cvs file using the `CVS input file´ and defined ; as a column delimiter.
    most of the fields are 10 to 40 positions long but one is very long.
    After this step I want to insert it in a database table using a blob field.

    But for now when reading the long field it translates an endoffline into end of record.

    What can I do to prevent this?

    Thanks.

    Bert.
    Attached Files Attached Files

  2. #2

    Default

    I sometimes have problems with the "Lazy conversion". You might want to retry after having switched it off in your CSV Input. If your file is big, you might also want to increase the NIO buffer size.

  3. #3
    DEinspanjer Guest

    Default

    The CSV step cannot handle line feed characters embedded in fields. Switch to using the Text File Input step instead. It is slower, but it has more features.

  4. #4
    Join Date
    Apr 2008
    Posts
    6

    Default

    When I use a Text File Input step and try to do ´preview rows´ I get a message ´this is not a replay transformation´

    Any ideas?

    Thanks.

    Bert.

  5. #5
    DEinspanjer Guest

    Default

    It is just a notification. It doesn't mean anything is wrong.

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.