SETFILTER AND * CHARACTER - FILE RECORD

andy76

Hello,

I am trying to filter all file in a folder having file name that starts with 2 character, for example CU.

I use Record File No. 2000000022 and following code:


SETRANGE(Path,'C:\TEMP\');
SETFILTER(Name,'=%1*','CU');
SETRANGE("Is a file",TRUE);
IF FINDSET THEN


FINDSET return always false also if in the folder there is a file called: CU20091104183810.txt.

If I comment filter on Name FINDSET is true. Why this?
How can I apply right filter?

Thank you

kapamarou

Try:

SETFILTER(Name,'CU*');

andy76

CU was an example because in my case it is a variable as following


SETFILTER(Name,'=%1*',gRecNESSetup."Customer File Prefix");

Is it possible to do as following?



SETRANGE(Name,gRecNESSetup."Customer File Prefix" + '*');

andy76

SETRANGE(Name,gRecNESSetup."Customer File Prefix" + '*');

doesn't filter correct

FINDSET return false

kapamarou

SETFILTER(Name,gRecNESSetup."Customer File Prefix" + '*');

Have you tried it?

kapamarou

You can also try:

SETFILTER(Name,'@' + gRecNESSetup."Customer File Prefix" + '*');

to make it case insensitive...

andy76

Yes, it's OK, Solved, Thank you very much

kapamarou

You're welcome.

garak

Read also this:

viewtopic.php?f=23&t=37018