US and Worldwide: +1 (866) 660-7555
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,534

    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
    Matt Casters, Chief Data Integration
    Pentaho, Open Source Business Intelligence
    http://www.pentaho.org -- mcasters@pentaho.org

    Author of the book Pentaho Kettle Solutions by Wiley. Also available as e-Book and on the Kindle reading applications (iPhone, iPad, Android, Kindle devices, ...)

    Join us on IRC server Freenode.net, channel ##pentaho

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •