Page 1 of 1

pulling a file with a future date embedded into the name

Posted: Tue Mar 22, 2016 11:02 am
by Joshua1313
Good morning everyone
I am trying to create a job that pulls a remit file created on Monday, but has an embedded timestamp for the future Thursday, but it is not prefixed or suffixed to the file name, it is smack dab in the middle.

Again these are created on Monday 20160321 but have the future Thursday date in them 20160324

ssi00243.20160324.pbcreg.8355010.zip
ssi00243.20160324.pbcfep.8355010.zip
ssi00243.20160324.pbcdom.8355010.zip

There is no clean up on the source side, so I cant clear out the folder so that only these will be there, and just pull a *.zip. There is also a lot of other files we do not use for the job requested that can not be touched. The date portion is the only portion that is changing between like files.

Is it possible to just grab those files for the future date in their name, when that is the only thing changing?
ssi00243.{current_date +3}pb*.zip

I don't know XML, and request that anyone who has some hints/tips on how to accomplish this, pretty please, show it in the Director Task set up.

I am very new using this program, and require a methodical mundane approach so that I can understand how this can be manipulated.

Thanks in Advance

Joshua1313

Re: pulling a file with a future date embedded into the name

Posted: Fri May 06, 2016 12:32 pm
by Support_Rick
Yes, you can generate a variable like you described for Today + 3 by using the TIMESTAMP task.

This allows you to create a date variable then, on the "Manipluation" tab, just use a +3 for the value.

Then, you could create your file list variable (or Fileset as part of a Zip/copy/move) and include only files with the pattern:

ssi00243.${ToDate}.pb*.zip