Re: [RBASE-L] - Grab file names in a folder

Thu, 10 Oct 2019 10:44:40 -0700 

Use SGET, you might have to adjust the position and length.

SET VAR vFileName = (SGET(.vDataTmp,32,42))

Doug

On 10/10/2019 12:17 PM, Dan Goldberg wrote:


I did the output and it gives me all the info.

Volume in drive \ has no label.

Volume Serial Number is N/A

Directory of \\appserv3\salesdb\

10/02/2119  12:47 PM                 594 aa.RMD

06/04/2118  06:30 AM               5,479 bobsmonthly.rmd

09/30/2119  08:21 AM                 899 bowler.rmd

09/25/2119  02:46 PM              11,531 dashboard.rmd

04/03/2118  03:20 PM               5,137 dealerloactorapp.rmd

07/24/2119  01:03 PM               1,344 DealerLocatorUpdate.rmd

09/03/2119  10:12 AM              10,227 inv1spnodel.rmd

           7 File(s)              35,211 bytes

           0 Dir(s)                    0 bytes free

Is there a way just to get the file name and not the other info?

Dan Goldberg
*From:* [email protected] <[email protected]> *On Behalf Of *Dan Goldberg 
*Sent:* Thursday, October 10, 2019 10:06 AM
*To:* [email protected]
*Subject:* RE: [RBASE-L] - Grab file names in a folder

Thx Albert. That will work!

Dan Goldberg
*From:* [email protected] <mailto:[email protected]> <[email protected] <mailto:[email protected]>> *On Behalf Of *Albert Berry 
*Sent:* Thursday, October 10, 2019 10:04 AM
*To:* 'jim schmitt' via RBASE-L <[email protected] <mailto:[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,
    visithttp://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 [email protected]
    <mailto:[email protected]>.
    To view this discussion on the web
    
visithttps://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 <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 <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/2E4830CEC16615458329D3D83342F8D0011EBAAE75%40EXCHANGE10 <https://groups.google.com/d/msgid/rbase-l/2E4830CEC16615458329D3D83342F8D0011EBAAE75%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/2E4830CEC16615458329D3D83342F8D0011EBAAF4D%40EXCHANGE10 <https://groups.google.com/d/msgid/rbase-l/2E4830CEC16615458329D3D83342F8D0011EBAAF4D%40EXCHANGE10?utm_medium=email&utm_source=footer>. 



---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus

--
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/b94afa85-98ad-159d-f866-d88556e21883%40wi.rr.com.

Reply via email to