Loading files - Removing bits!

[dinicholls]

Hi,

I have a bunch of files that I need to load on a daily basis. This isn't a problem, as they are all basically the same, bar the ending.

My question is, how can I remove the digits on the end so QlikView will load the file and I don't have to keep changing the numbers each day?

Here's an example of the file name, the numbers in bold being the bit I need to remove!

MI_029_ADT_LDM_Due_280119.csv

Thanks

Di

 

[Anonymous · Accepted solution]

load MI_029_ADT_LDM_Due*.csv

or

load MI_029_ADT_LDM_Due_??????.csv if you want 6 characters and not more

[dinicholls]

Doh!

That easy?!

I'll give it a go!

Thanks!