Hitachi Vantara Pentaho Community Forums
Results 1 to 6 of 6

Thread: Want to pick a file which contains today's date in it

  1. #1
    Join Date
    May 2006
    Posts
    6

    Default Want to pick a file which contains today's date in it

    Attachment: process and move files.PNG Hi, We are working with kettle, here we have a scenario
    · We have a folder called "CURRENT" in that we have a file; we have to check whether that file contain today's date in its name (We wont pass the file name to Kettle it has to check, We will give the Folder path).





    · If there is a file matching with today’s date then we have to pick that file and we have to move that file to “PROCESS” folder.






    · If the filename won’t have today’s date in its name then we have to move that file to “ERROR” folder.






    · Is it possible with Kettle?






    Please send me a code that will check the date in mmddyyyy formate, my source file is like "file1_05172006"



    Thanks & Regards






    Sas

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

    Default RE: Want to pick a file which contains today's date in it

    Hi Sasi,

    This is not YET possible with Kettle. Give it a couple of weeks.
    I will probably do a Weekly Tip on Jobs that do these kind of things next week.

    Thanks,

    Matt

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

    Default RE: Want to pick a file which contains today's date in it

    Attachment: process and move files.PNG Mmm, see attachment, latest version only!

    ;-)

    Matt

  4. #4
    Join Date
    May 2008
    Posts
    26

    Default

    Quote Originally Posted by MattCasters View Post
    Attachment: process and move files.PNG Mmm, see attachment, latest version only!

    ;-)

    Matt
    Hello Matt,

    I am in need of the same function. I see that you have a link for the solution, but it does not work. Can you assist?
    Lloyd
    Software Implementation Specialist

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

    Default

    Shees Lloyd, that was 3 years ago.

  6. #6
    Join Date
    May 2008
    Posts
    26

    Default

    yeah, I know....I live in the past....bad habit
    Lloyd
    Software Implementation Specialist

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.