cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
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