- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
How to save a file with name as a variable in For loop to save multiple files
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" );
2 REPLIES 2
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: How to save a file with name as a variable in For loop to save multiple files
Hi
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.
"I thought about our dilemma, and I came up with a solution that I honestly think works out best for one of both of us"
- GLaDOS
- GLaDOS
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: How to save a file with name as a variable in For loop to save multiple files
Hi, Thanks a lot.
It works now.