Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: filter a column based on pattern

  1. #1

    Default filter a column based on pattern

    hello

    I tried to seacrh but couldnt find anything regarding the string filter

    I am trying to filter out a column based on a pattern. That is if the value exits in the pattern it should write that out else ignore that value in the column

    Example:

    Col1="BCDWZYG0123"
    var pattern= "ABCDEF0123456789"

    output should be BCD0123H .. (Excluding WZYG)

    How can i do this


    Any help would be appreciated

    Thanks

  2. #2

    Default modified java script

    Hi Casper

    If I understand you correctly, then I would suggest you use the modified java script and loop through the variable/column truncating anything that is found in the exclude pattern.

    Regards
    Paul

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.