topic How to perform File Functions on multiple files. Looks like I can't use wildcards? in Discussions

How to perform File Functions on multiple files. Looks like I can't use wildcards?

miguello — Fri, 21 Jun 2019 21:29:06 GMT

How do I perform File Functions on multiple files using wildcards? Let's say after finished with files I'd like to sort them into corresponding folders like that:

Move Files("c:/temp/*.jmp", "c:/temp/processed_jmp/");

Move Files("c:/temp/*.csv", "c:/temp/processed_csv/");

Looks like this won't work with wildecards. I'd hate to go into getting list of all files, break it into separate lists for each extension, then making FOR loops to iterate through each file.... Is there a more elegant way of doing that?

Re: How to perform File Functions on multiple files. Looks like I can't use wildcards?

miguello — Fri, 21 Jun 2019 21:58:54 GMT

Right now I have it implemented this way:

path = "c:/temp/";
pathProcessed = path||"processed/";
listOfFiles = Files In Directory(path);

for(i=1, i<=N Items(listOfFiles), i++, 
if(Contains(listOfFiles[i], ".jmp")>0, Move File(path||listOfFiles[i], pathProcessed||listOfFiles[i]));	
	
	
);

but it looks awkward...

Re: How to perform File Functions on multiple files. Looks like I can't use wildcards?

Craige_Hales — Sat, 22 Jun 2019 12:22:07 GMT

You could use RunProgram, something like this (lots of setup for a complete example)

Delete Directory( "$temp/aaa" ); // make sure source is empty
Create Directory( "$temp/aaa" );

Save Text File( "$temp/aaa/a1.txt", "a" );
Save Text File( "$temp/aaa/a2.txt", "aa" );
Save Text File( "$temp/aaa/a3.bad", "no suffix" );

Delete Directory( "$temp/bbb" ); // make sure dest is empty
Create Directory( "$temp/bbb" );

aaa = Convert File Path( "$temp/aaa", "windows" ); // "C:\Users\v1\AppData\Local\Temp\aaa"
bbb = Convert File Path( "$temp/bbb", "windows" ); // "C:\Users\v1\AppData\Local\Temp\bbb"

aaawild = aaa || "\a*.txt"; // wild card *

result = Run Program( Executable( "CMD.EXE" ),
 Options( {"/a", "/q", "/c move ", aaawild, bbb} ), ReadFunction( "text" ) );

Write( result );

Show( Files In Directory( aaa ) );
Show( Files In Directory( bbb ) );

C:\Users\v1\AppData\Local\Temp\aaa\a1.txt
C:\Users\v1\AppData\Local\Temp\aaa\a2.txt
2 file(s) moved.

Files In Directory(aaa) = {"a3.bad"};
Files In Directory(bbb) = {"a1.txt", "a2.txt"};

/a and /q are options for CMD.EXE, and /c passes the move command to CMD.EXE.

Re: How to perform File Functions on multiple files. Looks like I can't use wildcards?

miguello — Tue, 25 Jun 2019 22:36:52 GMT

Yeah, I wouldn't call this more elegant. I've seen this solution, yes, but I'd rather stick to my current solution.
Thanks a lot!