Use Dynamic File path OR dynamic file name in CSV writer? (2 replies)
Have you enabled the 'Evaluate File Name'?
Thanks
Thank you, I completely blew past that. And I was also trying to use Expando fields in the file path itself, and that threw a "syntax error." But once I just used a plain vanilla path, and moved all the Expando fields to the file name itself, I was back in business. Thank you for pointing that out.
Hi there,
I can't seem to get something working and hope you have advice. I need to create a file each month and want the names to include a field called %FileDate so that they are date-stamped. I am trying to either:
Dim Dir
Dir = "\\GroupDocs\Sage2019\IMAN_File\" & %FileName
CreateFolder(Dir)
Both of these attempts result in an error:
"Illegal characters in path."
I'm confused by the illegal characters. The characters in %FileName are: 2020-04-23_Invoices
I've also tried to change the expando field from %FileName to ones that are strictly letters. Same result.
So is this possible? I was referencing this page, which shows exactly what I want to do:
https://www.realisable.co.uk/support/Documentation/iman-user-guide/IOControllers/File.htm