Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Filename Validation

  1. #1
    Join Date
    Mar 2009
    Posts
    1

    Default Filename Validation

    Hi Guyz,

    I am a newbie on Pentaho Kettle forum and i am very excited to work with this tool. I need to check the filename format (ex:title_id_date) the file name should be in that format. so can u help to validate filename it would be greatful if give a clear idea on this issue.

    Thankq,
    Chandra.

  2. #2
    Join Date
    Nov 1999
    Posts
    9,729

    Default

    Looks like a job for a regular expression, in this case that expression is something like:

    Code:
    \w*_\d*_[1-2][0-9][0-9][0-9]\.txt$
    You can use that regular expression as a wildcard in the "Get Filenames" step or in the "Data Validator" / "Regular Expression" step.

    Matt

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.