Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Quick question about text input step.

  1. #1
    Join Date
    Mar 2006
    Posts
    683

    Default Quick question about text input step.

    I know it's been a while since I have used kettle to the extent that I'm waiting to again. I use to recall how to do it but I'm unable to get it.

    I got this text file that's only got so many fields tab delineated then the last field that may or may not have tabs in it I want grouped together.
    a sample bit:

    value1 TAB value2 TAB value3(with tabs in it)
    value1 TAB value2 TAB value3(with no tabs in it)

    desired captured output:
    value1, value2, value3(including tabbed data)
    value1, value2, value3(including no tabbed data)

    Can you give me a pointer or point me to someplace that will help me.
    I did a bit of looking in the samples and some other researching, so I might have missed something.
    I can get value1 and value2 but value3 is the issue which it chops off after the last tab.

    Any suggestions is appreciated.

    Thanks and Cheers,

    Nic
    Try not to have too much fun.
    - - - -
    Nic Guzaldo
    That guy who shows up here
    and there

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

    Default

    Grab the whole line and do the split in another step?

  3. #3
    Join Date
    Mar 2006
    Posts
    683

    Default

    that's basicly what i'm wanting to do, but grabbing the whole line seems to be also troubling me.
    I'm probably just trying to make it too complex. I haven't poked at it too much lately.. gotta love meetings.. :-)
    I'm sure it's in one of the samples but I'm thinking I over looked it.

    mainly grab the line with or without the initial brake out, was planning on braking the other valued info via js step.

    thaks for the reply,

    nic
    Try not to have too much fun.
    - - - -
    Nic Guzaldo
    That guy who shows up here
    and there

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.