LOAD all files starting with XXX

[#1]

Hi I need to load all files starting with XXX.

I usually just load all files regardless of the name (see below)

but how do I load the files starting with XXX only?

FROM

(biff, embedded labels, header is 2 lines, table is @1)

[Peter_Cammaert · Accepted solution]

LOAD *

FROM (biff, ...);

[simospa]

LOAD *

FROM

(ooxml, embedded labels, table is Sheet1);

[#4]

Hi,

Please try the following

FROM

(biff, embedded labels, header is 2 lines, table is @1)

Regards,

Joshmi

[hariprasadqv]

Wild card characters are very help full when doing are including matching pattern or style of input.

Ex: *XXX.xls allows Any string in place of astrict i.e  '*'

Wild card Entry     Allowed format of Date

*XXX.xls                        hai123XXX.xls

XXX*.xls                        XXXhai123.xls

*XXX*.xls                       hai123XXXhai123.xls

*.xls                               Loads all .xls files

Note: Here i am using hai123 in place of *, actually it will allows any value in place of astric