Hitachi Vantara Pentaho Community Forums
Results 1 to 7 of 7

Thread: Problem with file name

  1. #1

    Default Problem with file name

    Hi all,
    I've got a problem with files i want to get.
    These files are named XXX.YYYYMMDD_HHmmss (where YYYYMMDD is the date and HHmmss the hours)
    But my problem is I don't know the hours in the name of my file.
    I know I have a file a day so I created an environment variable for the date but I don't know how to get the end of the filename...

    I hope I explained it well.

    Thanks for your help.

    Anaïs

  2. #2
    Join Date
    May 2006
    Posts
    4,882

    Default

    Use a wildcard for the time?

    Regards,
    Sven

  3. #3

    Default

    Hello Sven,
    in fact I tried with a wildcard but it said XXX.YYYYMMDD isn't a folder

  4. #4
    Join Date
    May 2006
    Posts
    4,882

    Default

    You filled it in the wrong field?
    Sven

  5. #5

    Default

    Well, I don't know, I attach a test if you can tell me.
    The variable TEST is XXX.YYYYMMDD
    Where do I have to put the wildcard ?

    Thanks very much.
    Attached Files Attached Files

  6. #6
    Join Date
    May 2006
    Posts
    4,882

    Default

    LOL ... fill in directory in Field "File or dircetory", filename including wildcard in "Regular Expression". Then press add. Currently you have "path and file" as directory and txt as wildcard.

    Regards,
    Sven

  7. #7

    Default

    Thank you very much for your help Sven.
    it' ok now.
    In fact I thought I couldn't put environment variable in the regular expression because I didn't see the sign '$'
    But it's working.

    Best regards
    anaïs

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.