Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Dynamic regex matching with fields in a stream

  1. #1
    Join Date
    Jun 2011
    Posts
    2

    Default Dynamic regex matching with fields in a stream

    Hi everybody,

    I'm looking for a way to do a regex matching on a table field. I already tried the User Defined Java Class step, but was not successful.

    My input stream has several fields:
    Field A: the value to check
    Field B: the regex for matching
    Field C: a value, if the matching is not successful
    Field D: the result field to insert value of Field C, if matching is not sucessful

    Some help and hints is much appreciated!

    Regards,
    Dirk

  2. #2
    Join Date
    Nov 2008
    Posts
    777

    Default

    I think the Filter Rows step is the place to start. That will create two branches, one that matches and one that doesn't. A Calculator step in each branch should take care of the rest.
    Last edited by darrell.nelson; 09-13-2011 at 05:28 PM.
    pdi-ce-4.4.0-stable
    Java 1.7 (64 bit)
    MySQL 5.6 (64 bit)
    Windows 7 (64 bit)

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.