Skip to content

pulling a file with a future date embedded into the name

Post any question you may have in regards to GoAnywhere Director and let our talented support staff and other users assist you.
  • Joshua1313 Offline
  • Posts: 1
  • Joined: Tue Mar 22, 2016 10:18 am

pulling a file with a future date embedded into the name

Post 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
  • Support_Rick Offline
  • Support Specialist
  • Posts: 590
  • Joined: Tue Jul 17, 2012 2:12 pm
  • Location: Phoenix, AZ
  • Contact:

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

Post 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
Rick Elliott
Lead Solutions Consultant
(402) 944.4242
(800) 949-4696
Post Reply