Dan, Import the file names to a temp table and delete as they are completed.
Output ThisDir.dat DIR *.csv Output screen Create temp table … Decl cursor c1 for select from temp table Proc 1st Del from … where count= 1 Sele count(*) into vNumFilesLeft - - when zero, exit Proc Next Albert > On Oct 10, 2019, at 10:47, Dan Goldberg <[email protected]> wrote: > > I need to write a routine that will grab a file, import it, process it, > delete it, then grab then next file until they are done in that folder. > > What command do I use to grab the file name if I do not know the name? They > will be csv files. > > TIA > > Dan Goldberg > > -- > For group guidelines, visit > http://www.rbase.com/support/usersgroup_guidelines.php > <http://www.rbase.com/support/usersgroup_guidelines.php> > --- > You received this message because you are subscribed to the Google Groups > "RBASE-L" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected] > <mailto:[email protected]>. > To view this discussion on the web visit > https://groups.google.com/d/msgid/rbase-l/2E4830CEC16615458329D3D83342F8D0011EBAAD08%40EXCHANGE10 > > <https://groups.google.com/d/msgid/rbase-l/2E4830CEC16615458329D3D83342F8D0011EBAAD08%40EXCHANGE10?utm_medium=email&utm_source=footer>. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/CAD6CB61-82A0-4EA4-B98B-7B592EADF864%40albertberry.com.
