Thx Albert. That will work! Dan Goldberg
From: [email protected] <[email protected]> On Behalf Of Albert Berry Sent: Thursday, October 10, 2019 10:04 AM To: 'jim schmitt' via RBASE-L <[email protected]> Subject: Re: [RBASE-L] - Grab file names in a folder 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]<mailto:[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 --- 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]<mailto:[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<https://groups.google.com/d/msgid/rbase-l/CAD6CB61-82A0-4EA4-B98B-7B592EADF864%40albertberry.com?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/2E4830CEC16615458329D3D83342F8D0011EBAAE75%40EXCHANGE10.
