topic Re: how can I extract the names of scripts in a folder then execute them? in Discussions

how can I extract the names of scripts in a folder then execute them?

AlanBell — Thu, 08 Jun 2023 16:44:22 GMT

I am trying to extract the names of files in a subfolder and then extract them,

So far I am using the

Files in directory()

And getting a list and adding to a data table, but I am struggling to get from here to an executable jsl file that will run them all.

Any assistance would be great

thanks

Re: how can I extract the names of scripts in a folder then execute them?

jthi — Thu, 05 Jan 2023 14:05:37 GMT

I don't understand this part: "And getting a list and adding to a data table"

Depending where you are executing the scripts from you can use Include() (files) or << Run Script (table scripts)

Re: how can I extract the names of scripts in a folder then execute them?

AlanBell — Thu, 05 Jan 2023 15:30:18 GMT

When getting files in directory it wasn't including the full path, so I was adding the list to data table and adding the rest of the path and semi colons to get the syntax correct.

I was hoping to include the names as a script with a load of include and file names. And have the file in task scheduler and running every day etc

Re: how can I extract the names of scripts in a folder then execute them?

Jed_Campbell — Thu, 05 Jan 2023 15:44:00 GMT

lstFiles = Files in Directory ("$SAMPLE_DATA\Loss Function Templates");

for each ({i}, lstFiles,
	//if extension is .jsl, then it's a script, and should be executed
	if (right(i,3)=="jsl", include("$SAMPLE_DATA\Loss Function Templates\"||i));
);

//put values in a new data table
dt = new table ("table",
	new column ("Fname", character, set values (lstFiles))
);

This should be what you're looking for. The bit about putting the list in a table doesn't do anything, other than put them in the table, so unless you actually need the filenames in a table, this can be skipped.

Re: how can I extract the names of scripts in a folder then execute them?

AlanBell — Fri, 06 Jan 2023 16:17:26 GMT

Thanks for that, worked great. What are the changes that would cause it to fail in JMP 14 but not 16.

Re: how can I extract the names of scripts in a folder then execute them?

Jed_Campbell — Fri, 06 Jan 2023 16:24:51 GMT

My guess is the For Each loop structure is failing in JMP 14. I think that was added in JMP 15. You can replace that with a traditional For () loop for JMP 14.