Toad World® Forums

Anyone know how to get file names into an automation variable?

I want to get a list of file names in a particular folder on a network drive (FTP dump location). I want to be able to tell if any files are present and then if they are to process each file. The names will always be similiar with a different date suffix each time. I may also want to do some date checking on that date suffix part of the name which will always be in the same position in the file name. Any ideas?

We have a solution for this type of scenario if you want to do a conditional FTP download or process a group of files and import them. See this Blog and see if this covers your needs.

http://toadworld.com/Blogs/tabid/67/EntryId/652/Processing-Folders-New-in-Toad-for-Data-Analyst-v2-7.aspx

Debbie