836224_en-US

liliconcom

Save JMP file generated using import function to specific location with specific name.

I am importing multiple file from using import function. I want to save it automatically outside the folder and with same name.

 

Basic Data Analysis and ModelingRe: Save JMP file generated using import function to specific location with specific name.

I assume you want to save files found from Sample Data folder into single JMP table named Sample Data.jmp which is on the same level as the folder.

Names Default To Here(1);

xlsx_dir = "$DOWNLOADS/JMP example/Sample data/";
dir = Convert File Path(xlsx_dir, posix);

dts = Multiple File Import( // will return a list
	<<SET folder=""></SET>

Modify as needed, this provides some ideas on how to "traverse" the directory path using Word()

Re: Save JMP file generated using import function to specific location with specific name.

Thanks for the explanation. I worked fine. 

 

I was able to get file name but was strugalling with saving it.

//File name=reverse(words(dir,"/"))[1];
//dt << Set Name(wafer);

Re: Save JMP file generated using import function to specific location with specific name.

Word(-1, str,) is basically same as Reverse(Words(str))[1]. Learning how to utilize both Word and Words can be very helpful (and sometimes Item and Items())

Names Default To Here(1);

my_str = "http://www.jmp.com";

r1 = Word(-1, my_str, ":/.");
r2 = Reverse(Words(my_str, ":/."))[1];

Show(r1, r2);