how do I get qlikview to match certain file names

[#1]

I am doing this: For each vFile in FileList('..\LooseDataFiles\*Capabilities.xlsx') however I dont want it to match the Capabilities.xlsx file only the filenames with stuff before it like 2010Capabilities.xlsx?

[rustyfishbones]

Here is an example where it worked for me on my example files

[#3]

Alan's solution is ideal. Just made a small change to it.

Load *

From *capabilities

Where FileBaseName() <> 'capabilites' ;

This wont read from capabilities table but from everything else.

[rustyfishbones]

Hi Ajay,

I have tried this method and it does not work for me.

FileBaseName gives you everything before the file extension.

Which in Christopher's case, he only wants files that contain text before Capabilities.xlsx

Capabilities.xlsx contains 17 Characters and therefore if Chris uses FileName()

Where the length of the FileName() is greater than 17 it will only load those files

Regards

Alan

[#5]

Oh.. In the example he provided some had numbers as well.

2013 capabilities

abscapabilities

a b s capabiltiies

12s capabiltiies

q22capabilities

I was of the opinion he wanted anything which had something before capabilities but not just capabilities.

Sorry if my interpretation was wrong.

But either way I think Chirs has a solution now.

[rustyfishbones]

I must try your solution again