Load excel files where the name start with s

[zied_ahmed1]

Hello everybody,

I would like to load some excel files from a LIB and the condition that i load all fields of an excel file where the name start with *s*

Thanks for help

[tomasz_tru]

You can use wildcard in the script

s*.xls

[zied_ahmed1]

can you please give me an example ?

Thank you

[dwarikapanigrah · Accepted solution]

Hi Zied

Try this -

LOAD *

FROM

(biff, embedded labels, table is Sheet1);

Where  '*' is a wild character

[zied_ahmed1]

Yes it works..just we need to change path to LIB Thank you