Choose Language Hide Translation Bar
Nalla
Community Trekker

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

 

0 Kudos
1 ACCEPTED SOLUTION

Accepted Solutions
Nalla
Community Trekker

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

0 Kudos
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
Community Trekker

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

0 Kudos
txnelson
Super User

Re: Saving files to created folder

oops, my typo....sorry

Jim
0 Kudos