Loading a list of files

[janardhan]

Hi Freinds,

I have some log files like log-20-07-2015.php files for so many different dates in local netwrok location.

I need to load all log files.

Can anyone please help.

Thanks in advance

Janardhan

[qumniusomnius · Accepted solution]

load

*

from \\filepath\log-*.php;

[janardhan]

Thank u so much its working

[janardhan]

Hi Borja,

I have one more requirement , i need to load only last 10 days log files.

Can u pls help me

[qumniusomnius]

there is probably some nicer way to do this, but something like this:

let load1= '\\filepath\' &  date(num(today())-10,'DD-MM-YYYY')

let load2= '\\filepath\' &  date(num(today())-9,'DD-MM-YYYY')

etc.

then:

load

*

from $(load1);

load

*

from $(load2);

you can probably do the loads in a for loop, dont have time to try it out now,

good luck!

[#6]

Useful Post