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.
2 posts Page 1 of 1

Joshua1313

Posts: 1
Joined: Tue Mar 22, 2016 10:18 am

Post by Joshua1313 » Tue Mar 22, 2016 11:02 am
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

Support Specialist
Posts: 590
Joined: Tue Jul 17, 2012 2:12 pm
Location: Phoenix, AZ

Post by Support_Rick » Fri May 06, 2016 12:32 pm
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
2 posts Page 1 of 1