How to Check whether the filename is todays file or not(filename like CLM_2014050).

Question

How to Check whether the filename is todays file or not(filename like CLM_2014050).

naresh0407

Old Hand

Points: 362
More actions
April 5, 2014 at 6:02 am

#291919

Hi All,
I have file name like this CLM_20140504.I will get file everyday..I just need to check whether file is today's file and then process it.Please let me know how we can do this.
CLM will be common and date should be today's date.tomorrow file name will be CLM_20140604.I need to compare current date with filename date i.e 20140504.
Thanks

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Phil Parkin SSC Guru Points: 246695 More actions · Answer 1

naresh0407 (4/5/2014)
Hi All,
I have file name like this CLM_20140504.I will get file everyday..I just need to check whether file is today's file and then process it.Please let me know how we can do this.
CLM will be common and date should be today's date.tomorrow file name will be CLM_20140604.I need to compare current date with filename date i.e 20140504.
Thanks

The standard way of doing this is to archive the file to a different folder after processing it.

So your import (or whatever) just processes what is in the 'infiles' folder, regardless of its name.

One of the problems with your proposed method is what to do if the server is down for a day - you have to mess about forcing yesterday's file to be processed.

Another problem you will get is that the number of files in the folder builds up over time and you'll never be sure that all of them have been processed.

If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.

naresh0407 Old Hand Points: 362 More actions · Answer 2

Thanks for the reply..Just need to validate the filename CLM_20140504..Could you please let me know how can we validate.Today date is 20140504 so the CLM_20140504 is valid file.

File name should be with today's date.

If the file name is CLM_20140404 then this is yesterday's file so not valid.So we cannot process yesterday's file today since date in the file 20140404.

Eirikur Eiriksson SSC Guru Points: 182882 More actions · Answer 3

naresh0407 (4/5/2014)
.Just need to validate the filename CLM_20140504..Could you please let me know how can we validate.Today date is 20140504 so the CLM_20140504 is valid file.

Assuming that you have gotten the file name in a variable, then split it (remove the prefix) in an expression to retain the date part. Use an execute sql task to run this code on the sql server

select convert(varchar(32),getdate(),112)

and compare the two.

😎