pulling a file with a future date embedded into the name
Posted: 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
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