Getting fussy with GETFILE() 2

[SGLong]

I need to find a way to restrict the list of files that GETFILE() sees to files that begin with a fixed prefix (i.e. B00) and have NO EXTENSION. Examples of the files I need to restrict the list to are B00D0601, B00F0601, etc.

I'd be willing to settle for listing extensionless files regardless of the prefix, but GETFILE either gives me all files or nothing.

Any ideas?

Steve

 

[foxdev]

Its a longer way around, but it gives you a chance to create a class you can use later

Use ADIR(), then (if needed) filter the files to only those you want, and display in your own form. Robert Bradley
Sr. DBA, some big company
cheap prints and oil paintings:

http://www.lowcostprints.com

 

[ramani]

You can use ADIR() to get only required files... by using
=ADIR(myDir,"BOO*.*&quot
then use the array myDir to get whatever you want.

ramani :-9
(Subramanian.G)
FoxAcc
ramani_g@yahoo.com
LET KNOW IF THIS HELPED. ENOUGH EXPERTS ARE HERE TO HELP YOU OUT! BEST OF LUCK

 

[SGLong]

Bob and Ramani:

I combined both of your suggestions and created my own form class that gives me a whole lot more functionality than GETFILE() ever could have. It was a little time consuming, but worthwhile things are never easy. Thanks.

:-D

Steve

 

[foxdev]

Well, Steve, this is a plug-in that you'll be able to use over and over again. Are you able to post the code, perhaps as a FAQ? (I realize that you, like many of us, may be under some nondisclosure requirements) Robert Bradley
Sr. DBA, some big company
cheap prints and oil paintings:

http://www.lowcostprints.com

 

[SGLong]

Bob:

With a little editing to remove the customer identification, I was able to submit the code to the FAQ section. I hope that other developers can take what I created and build upon it for their own needs.

Steve