Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I know I can use wildcards for filenames, as in (random example):
LOAD * FROM Employee_*_2011.xls;
But is it possible to use it in full paths? Example:
LOAD * FROM C:\Employees\YEAR_*\Employee_*.xls;
If not, is it possible to create a function for this?
Thanks a lot!
Andy
Hi.
You can use one loop in all directories. For example:
let Root = 'Path';
for each Dir in dirlist (Root&'\*')
for each File in filelist (Dir&'\*.xls')
Table:
Load X
FROM [$(File)] (biff, embedded labels, table is [Plan1$]);
next File
next Dir
Regards
Julian
Hi,
I think that just work in file name
Hi.
You can use one loop in all directories. For example:
let Root = 'Path';
for each Dir in dirlist (Root&'\*')
for each File in filelist (Dir&'\*.xls')
Table:
Load X
FROM [$(File)] (biff, embedded labels, table is [Plan1$]);
next File
next Dir
Regards
Julian
Hi Julian,
very cool. It works, just what I was looking for!
Best,
Andy