topic Re: Loading files - Removing bits! in QlikView

Loading files - Removing bits!

dinicholls — Thu, 25 Sep 2014 14:31:12 GMT

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

Anonymous — Thu, 25 Sep 2014 14:34:01 GMT

load MI_029_ADT_LDM_Due*.csv

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

dinicholls — Thu, 25 Sep 2014 14:36:36 GMT

Doh!

That easy?!

I'll give it a go!

Thanks!