Delete xls files

[#1]

Hi All.

I have a scenario with multiple xls files to load in QV. After the full load, the end user only want to charge the most recent file and delete the others. Can I automatically remove them since QV? I have already identified the most recent file, I just need to clarify if the rest of the files can be removed directly from QV.

Thanks for your attention.

[swuehl]

You can run windows command line commands from within the load script, have a look at EXECUTE in the Help.

The QV script line looks like

Execute cmd.exe /C "D:\YOURPATH\script.bat";

Instead of a batch file, you can call other windows commands, like DEL.

You may need to allow the script to execute in script editor -> settings.

[maxgro]

FOR each _vsFile in 'a.xls', 'b.xls' 

  SET _vsBatch = 'cmd.exe /C del "$(_vsFile)"  /Q';

  trace $(_vsBatch);

  EXECUTE $(_vsBatch);

NEXT;

[#4]

Thank's for your answers.

I tried using this syntax, but QV execute the cmd.exe instead of script.bat.

In QV:

EXECUTE cmd.exe C/ C:\script.bat;

The script.bat is simple:

DEL /P "C:\Hola Mundo.txt"

Any ideas?

[swuehl · Accepted solution]

Not yet, worked ok for me:

EXECUTE cmd.exe /C DEL /P "C:\Temp\test.txt";

[#6]

Thank's... It's working now.