Before version 4.0, it was not possible to use a regular expression in a Set Variable task. At version 4.0 and beyond, the Replace(text, regex, replacement) function may be used.

There are two versions of the SetVariable task. You can use the SetVariable Version 1 task anywhere but it will only get data from the first row of the rowset or fileset. If you want to loop thru the rows of a rowset or filest, you need to use the SetVariable version 2 task. If you are just changing...

Port 8001 is usually reserved for https so you would either need to specify - https://as400uat:8001/goanywhere or change the port to read - http://as400uat:8000/goanywhere

There is no need to add it to any of the GoAnywhere folders, but it does need to be in a folder located on the same system in which GoAnywhere is running. Then you just reference it from the Write Excel file task.

An Excel template file is nothing more than another Excel file with the headings and formatting that you want to specify for your file that you're creating in GoAnywhere Director. i.e. there is no specific requirement for a template file, it can be any Excel file you choose.

Use the print statement to write the last changed date out to a file, then read it in as a delimited file using a space as the delimiter. You then have to do a set variable version 1.0 task to get the date out of the rowset. It will be in yyyy-MM-dd format. If you don’t want the dashes, you can do a...

You could also place an entry in the "When No Data Found" field. The options are "continue" (the default) and "error" which throws an error and, depending on how "on Error" is set, can end the project at that point.

Add another query after the select statement query to count the rows selected. Something like : select count(*) from library.filename. If your select statement has a where clause, add that to this statement also. Add a Set Variable version 1.0 task (you’ll have to click the Include Prior Versions bo...

As of version 3.5.1 GoAnywhere Director does not have a WebDAV extension.

The certificate/chain needs to be imported into GAD/GAS's default trusted certificate store. When specifying the LDAP/Active Directory URL, type the URL using "ldaps://" instead of "ldap://" if secure connection is desired. A restart may be required after importing the certificates.