Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Dealing with Hard Returns Inside Field (text file import)

  1. #1

    Default Dealing with Hard Returns Inside Field (text file import)

    Hello,


    Is there a graceful way to deal with hard returns found in delimited text files? Some of our sources have long "description" fields, which seem to be large arbitrary text fields.



    The text file export has kept these hard returns, and thus a new line in the text file is *not* a new record.



    Does Kettle have a way to handle this? The file is delimited, so it might be able to know that it isn't done reading in a full record.



    Thanks,
    Seth

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

    Default RE: Dealing with Hard Returns Inside Field (text file import)

    Hi Seth,

    At the moment support for hard returns in delimited fields is not yet available.
    I wanted to do it a couple of weeks ago but it was harder then I imagined because Text File Input works down the text file line per line, not field per field...
    I guess we'll be able to solve it somehow, but it just takes some time.
    There used to be a feature request for it as well, but I can't find it. This is a (another!) problem with the Javaforge software.
    Perhaps you can create another one? That way we don't forget ;-)

    All the best,

    Matt

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.