topic Re: Saving files to created folder in Discussions

Saving files to created folder

Nalla — Fri, 17 Feb 2017 00:03:35 GMT

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.

Re: Saving files to created folder

txnelson — Fri, 17 Feb 2017 01:16:36 GMT

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()), "/", "-", ":", "."));

Re: Saving files to created folder

Nalla — Fri, 17 Feb 2017 01:44:31 GMT

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

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

Re: Saving files to created folder

txnelson — Fri, 17 Feb 2017 01:55:47 GMT

oops, my typo....sorry