Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: HELP: How Do I Store RegExp(Wildcards) in variables?

  1. #1

    Default HELP: How Do I Store RegExp(Wildcards) in variables?

    I'm trying to use the Get File Names step to get a list of files in a folder. If I type this value: (?i)DATAFILE_101221.+\.CSV directly into the step, then it works.

    But if I store the same value in a variable and use the variable in the Get File Names step then it doesn't. What am I missing?

  2. #2
    Join Date
    Sep 2007
    Posts
    834

    Default

    It should work.
    Did you check the scope of your variable?
    Could you attach the sample transformation?

  3. #3
    Join Date
    Nov 2008
    Posts
    143

    Default

    Could it be the \.CSV instead of \\.CSV ?

  4. #4

    Default

    Thanks for everyone's help. It turned out to be a logic problem. Fixed the problem and the process is picking up the files as desired.

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.