topic How to save a file with name as a variable in For loop to save multiple files in Discussions

How to save a file with name as a variable in For loop to save multiple files

Stokes — Fri, 09 Jun 2023 23:36:13 GMT

Hi, I am trying to save files in a for loop, the problem is how to put a variable into the file saving procedure,

However, it looks the file save part is not working.

I didn't use any clear global to make sure filename has be assigned with the original value.

Is there any problem with my saving part?

Thanks

// filename is a variable assigned below,
For( j = 1, j <= N Row( sdt ), j++,
filename = Column( sdt, "file" )[j];
Close( Data Table( sdt ), No Save );

// During saving the file, the directory is fixed, however the filename is an variable, 
// the goal is to use the left(filename,18) and concatenate with "_Type1" in the file name.

dt1 = Current Data Table();
dt1 << save( "C:\Users\file\JSL\"||Right( filename,18)||"_Type1.csv" );

Re: How to save a file with name as a variable in For loop to save multiple files

Mauro_Gerber — Fri, 28 Aug 2020 05:57:39 GMT

I chanched the code a bit so this may help:

Names Default To Here( 1 );
dt = Open( "$SAMPLE_DATA/Big Class.jmp" );

path = "C:\Users\file\JSL\"


For( j = 1, j <= N Row( dt ), j++,
	dt << save as (path || dt:name[j] || "_Type1.csv" );
);

It can be that you need to do a "save as" to make it work.

Re: How to save a file with name as a variable in For loop to save multiple files

Stokes — Fri, 28 Aug 2020 23:29:38 GMT

Hi, Thanks a lot.

It works now.