Identifying files w uncommon name syntax
Posted: Fri Nov 20, 2009 11:07 am
I am new to the application and am only using Robotask Lite for right now and have it doing some minor file copying and moving and then FTP type tasks, but now I need it to do something much more complex I was hoping you could help with.
I have basically 8 different paths that are similar to this:
T:\EAH\billing\uploadh
T:\MHS\billing\uploadh
etc
I need to create a wait task and then a copy and move task of files that are arriving via an FTP job from a vendor. I need to wait for files arriving in this file each day and copy/move them. The files are a specific EDI file type called an 835. The files are saved with a string syntax of 091009MA.835, 091009MB.835, etc where the filename string is the 2 digit year, 2 digit month, 2 digit day then the letter "M" which indicates the payor type which I want only the "M" there are other files in there like 091009BA.835 but I don't care about those files. I only want the "M" ones. These files also also get assigned another letter A, B, C, D, E, and on. Usually there are A, B, C, at least but sometimes the files get up to like G or H where it is 091116MH.835, on days with many files.
I can't figure out the variable to look for these files that arrive each day with this string structure. I need to get these files from each of the 8 or so paths then Copy these files to another location and rename them with the syntax of MHS sub root folder from above in the structure exampe MHS_091117MA.835. These files arrive by about 11am in the morning each day at the latest. I am such a newbie to all of this i can't figure out how to do a file monitor then search and move the files. If someone coudl point me in the right direction this I would be so appreciative and excited.
I have basically 8 different paths that are similar to this:
T:\EAH\billing\uploadh
T:\MHS\billing\uploadh
etc
I need to create a wait task and then a copy and move task of files that are arriving via an FTP job from a vendor. I need to wait for files arriving in this file each day and copy/move them. The files are a specific EDI file type called an 835. The files are saved with a string syntax of 091009MA.835, 091009MB.835, etc where the filename string is the 2 digit year, 2 digit month, 2 digit day then the letter "M" which indicates the payor type which I want only the "M" there are other files in there like 091009BA.835 but I don't care about those files. I only want the "M" ones. These files also also get assigned another letter A, B, C, D, E, and on. Usually there are A, B, C, at least but sometimes the files get up to like G or H where it is 091116MH.835, on days with many files.
I can't figure out the variable to look for these files that arrive each day with this string structure. I need to get these files from each of the 8 or so paths then Copy these files to another location and rename them with the syntax of MHS sub root folder from above in the structure exampe MHS_091117MA.835. These files arrive by about 11am in the morning each day at the latest. I am such a newbie to all of this i can't figure out how to do a file monitor then search and move the files. If someone coudl point me in the right direction this I would be so appreciative and excited.