Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.
Originally posted by: ryehI started writing this node before I realized there was already something similar on the forum. But I figured I'd post it anyway with a new title so that it's more searchable.
A customer asked how to write to a file such that the filename includes the date. That question addressed from this
thread, which I didn't find until afterwards.
As you can see, the attached graph offers four options, two for filepaths containing /'s (this is straight-forward) and two for filepaths containing \'s (not straight-forward as \ is an escape character).
In 1 and 2, the filepaths are typed into the Output Excel nodes as well as the following filter nodes that renames the files. The only difference between the two is that since \ is an escape character, the filter node needs to use \\ every time \ is used.
In 3 and 4, we've created parameters to specify the filepaths. Again, / in the filepath is straight-forward. A parameter that contains \ works fine in the Output Excel node, but not so much in the subsequent filter node. To make it work properly, I've assigned a run-time property name to the parameter specifying the filepath. This is explained in this
thread.
Attachments:
addDateToFilename.brg