Search files with a timestamp over system table

Martin_Förster

hallo,

i need some help!!!

i want to import multiples files like:

import_kunden_%timestamp%.csv

here my cal code:

timestamp := FORMAT(TODAY,0,'<Year4><Month,2><Day,2>');

datei_import := 'import_kunden_'+ timestamp+'*';

CLEAR(explorer);

explorer.SETRANGE(Path, "webshop einrichtung"."Pfad Import/Export");
explorer.SETRANGE("Is a file", TRUE);
explorer.SETFILTER(Name,'%1',datei_import);

but the code doesn't find anything!?!?!?

if i change the variable 'datei_import' with the string form a exiting file than it's OK!?!?!?

can anybody help me???

Marije_Brummel

Sometimes the filetable does not refresh. You can avoid this to change the filter on the folder with a '\' at the end of the filter.

This is also explained somewhere else on this forum.

kine

Please, try this:

timestamp := FORMAT(TODAY,0,'<Year4><Month,2><Day,2>');

datei_import := 'import_kunden_'+ timestamp;

CLEAR(explorer);

explorer.SETRANGE(Path, "webshop einrichtung"."Pfad Import/Export");
explorer.SETRANGE("Is a file", TRUE);
explorer.SETFILTER(Name,'%1*',datei_import);