Load pictures and save them again with a different filename
Hi,
I know it's possible to load pictures into QlikView. I'm not sure how right now since I haven't been working much with QlikView for a while now. The tool is not very much in focus these days.
Now, however, I have a task that I could very well use it for: I just need to load pictures saved with the .jpg ending - about 23.000, all with a seven-digit number as filename (like >> #######.01.jpg <<) - there are some with >> #######.02 << when the original ppt has two slides.
There is the task now to add to that seven-digit number another two digits, so the new format will be >> #########.01.jpg << - nothing else. I just have to load the files and save them again with the new name - the additional two digits aren't always the same, they have to be taken from another source, but that should not pose a problem.
I know right well that there are quite a lot of specific little tools for this task which would probably be faster because just renaming a file is logically faster than loading and saving it. The thing is that installing any kind of software in this company necessitates a rather lengthy process of checking and releasing by IT on different levels. So it would probably be easier to just do it with the tools we have. Runtime is not very critical as this will have to be done only once.
Can you tell me what would be the fastest way of doing this?
That seems to work. At least up to 12 - I'll just let it run to see if it counts all 112 or so files that I currently have, then I can build everything else based on that filename. And then I'll introduce that SLEEp statement you mentioned.
Wow! Works. Finally. Now I think we're going to get there.
It needs to look similar to this. I have removed the most comments and your concatenate-dummy-load (wouldn't be needed - see vConcatenate). The string-functions on the variable File needs to be checked and eventually adjusted.
