Subscribe Bookmark RSS Feed

Saving files to created folder

SOLVED
Nalla

New Contributor

Joined:

Feb 3, 2017

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

New Contributor

Joined:

Feb 3, 2017

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

 

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

3 REPLIES
txnelson

Super User

Joined:

Jun 22, 2012

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

New Contributor

Joined:

Feb 3, 2017

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

 

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

txnelson

Super User

Joined:

Jun 22, 2012

oops, my typo....sorry

Jim