Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Find, strip, and replace assistance

  1. #1
    Join Date
    Mar 2016
    Posts
    3

    Default Find, strip, and replace assistance

    I have a field that contains the following data

    CN=Testuser, OU=TestOU, OU=Domain

    I want to do the following:

    1. If the record being passed into my step has TestOU, strip everything except for TestOU and input that value into a field already in the stream called "Company"
    2. If the record being passed does not have TestOU, then do nothing to that record

    I can't determine best step to accomplish this.

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

    Default

    One might be tempted to suggest step Replace-In-String, but your field value resembles an LDAP distinguished name.
    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.