cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
JMP is taking Discovery online, April 16 and 18. Register today and join us for interactive sessions featuring popular presentation topics, networking, and discussions with the experts.
Choose Language Hide Translation Bar
Nalla
Level II

Saving files to created folder

Hi!

 

Would like to save a table to a folder created with jsl (Line #7). I have created a variable for it so that I can use it when indicating the directory I want to save my table(Line #27). However, after running the script, the variable("output") does not return the dir path but just the value "1". Thus, I could not save to my intended directory.

 

Am I missing someting here? Would appreciate any help.

 

Capture.PNG

 

1 ACCEPTED SOLUTION

Accepted Solutions
Nalla
Level II

Re: Saving files to created folder

Thanks much, Jim! Have added a slash to your suggestion and it worked. Appreciate the help.

 

OUTPUT = (dirpath||substitute(MDYHMs(Today()), "/", "-", ":", ".")||"/");

View solution in original post

3 REPLIES 3
txnelson
Super User

Re: Saving files to created folder

Your variable "output" returns the success or failure of the "Create Directory" function, 1 or 0.  If you want it to have the directory path as it value, use the following after creating the directory:

 

OUTPUT = dirpath""substitute(MDYHMS(Today()), "/", "-", ":", "."));

Jim
Nalla
Level II

Re: Saving files to created folder

Thanks much, Jim! Have added a slash to your suggestion and it worked. Appreciate the help.

 

OUTPUT = (dirpath||substitute(MDYHMs(Today()), "/", "-", ":", ".")||"/");

txnelson
Super User

Re: Saving files to created folder

oops, my typo....sorry

Jim