Oracle procedure create files on UNIX folder on a regular basis. I need to FTP files onto windows server and place the files, based on their name, in the corresponding folders. File name is as follows: ccyymmddfoldernamefile.txt; Folder Name length could be of any size; however, the prefix and suffix are of a fixed size.

e.g:
1) 20070701greenfieldincfile.txt (Folder Name: greenfieldinc)
2) 20070701oldenergycorpfile.txt (Folder Name: oldenergycorp)

Detailed Request:
1) Parse the Input File name and Find the name of the folder.
2) FTP to Windows server and place the text file in the corresponding folder.
3) Put the whole process in loop until it processes all files.
4) If possible any error check conditions or logs.

Thank you for your support!