topic Rename and move files using exe command in QlikView

Rename and move files using exe command

dsharmaqv — Wed, 25 Nov 2020 16:16:04 GMT

I have a requirement to rename all the files present in the folder by appending date to actual file name and move it to archive folder.

Can any one help me in achiving the functonality by using exe command.

Many thanks in advance!

Deepak

Re: Rename and move files using exe command

sibin_jacob — Wed, 08 Aug 2018 10:50:44 GMT

You can use this command

cd /home/webapps/project1/folder1 for f in *.csv do cp -v "$f" /home/webapps/project1/folder2/"${f%.csv}"$(date +%m%d%y).csv done

Re: Rename and move files using exe command

dsharmaqv — Wed, 08 Aug 2018 13:05:01 GMT

Thanks for your reply.

I am trying below for moving files, dont know how to rename and then move.

FOR each vFile in filelist('C:\Users\XXX\Desktop\ABC Dashboard\01SourceFile\*')

LET File = 'C:\Users\XXX\Desktop\ABC Dashboard\01SourceFile\*';
Let AFile = 'C:\Users\XXX\Desktop\ABC Dashboard\01SourceFile\Archive\';

Execute cmd.exe /C move /Y "$(File)" "$(AFile)";

NEXT

Re: Rename and move files using exe command

tamilarasu — Wed, 08 Aug 2018 15:26:20 GMT

Try this,

Let vSource = 'C:\Users\XXX\Desktop\ABC Dashboard\01SourceFile;
Let vArchive = 'C:\Users\XXX\Desktop\ABC Dashboard\01SourceFile\Archive';

For Each vFile in FileList('$(vSource)\*.*')

Let vNewFile = Replace(Subfield('$(vFile)','\','-1'),'.' & Subfield('$(vFile)','.','-1'), Date(Today(),'YYYYMMDD') & '.' & Subfield('$(vFile)','.','-1'));

EXECUTE cmd.exe /c Ren "$(vFile)" "$(vNewFile)";

NEXT;

EXECUTE cmd.exe /c Move /Y "$(vSource)\*" "$(vArchive)";