Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: Text file input filtering

  1. #1

    Default Text file input filtering

    I need some help on the filtering option on Text File Input but cannot find any examples on how this works online. Can someone please provide an example or two of what to put into the Filter String input box? Also, does this field accept RegEx patterns?

    BTW, I'm using Kettle 3.2.5.

    Thanks

    Gerald

  2. #2
    Join Date
    Jun 2012
    Posts
    5,534

    Default

    The Filter string must be a simple string literal, comparison is not case sensitive.
    Use a "Filter rows" step, if you crave for regular expressions.
    As always: Read the documentation - and don't be afraid to wet your feet.
    So long, and thanks for all the fish.

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

    Default

    That is not correct, comparison is indeed case sensitive.

    I would be interested to hear in which case it is not.

  4. #4
    Join Date
    Jun 2012
    Posts
    5,534

    Default

    Here is my test case.

    And here the relevant source code to back my case - excerpt from method doFilters():

    Code:
    ...
    if (sub.equalsIgnoreCase(filter.getFilterString())) {
    ...
    Attached Files Attached Files
    Last edited by marabu; 09-19-2012 at 07:21 AM. Reason: sorry for joking
    So long, and thanks for all the fish.

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.