How to filter on files to read in a network/disc.

[Anonymous]

Hi!

In my script I only want to read the files that ends with AVA. How can I solve this? Thanks.

[Anonymous · Accepted solution]

Use a wildcard.

Load *

From YourFolder\*AVA.xlsx;

[Anil_Babu_Samineni]

Simple load *youstring ??

[MarcoWedel]

another solution (having performance disadvantages because all files are loaded prior to filtering) but enabling other string operations on the filename also:

LOAD *

FROM *.xls

Where FileBaseName() like '*AVA';

hope this helps

regards

Marco

[Anonymous]

I can't get it to work 😕 This is my script and I get the following error messages.

Tab1

Tab2

[Anonymous]

Remove the comma after [SEL0004]

That doesn't belong.  That's why you're getting the red squiggly underlining.  And the other errors.

[Anonymous]

I still get the red underline and errors after removing the comma.

[Anonymous]

Oh you also need a comma after the *

So

Load *,

     DATE,

     [Branch Number],

     [SEL0004]

[MarcoWedel]

... and the semicolon between  .xls and where ...

So basically create a working LOAD statement first (e.g. using the file load wizard) and apply the "*" or "where" solution afterwards.

hope this helps

regards

Marco

[Anonymous]

Hi,

It still doesn't work and the end of the last row is red so something is wrong there. Do you see what it is?