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


    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


    var pattern= "ABCDEF0123456789"

    output should be BCD0123H .. (Excluding WZYG)

    How can i do this

    Any help would be appreciated


  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.


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.