Use SendEvent or Send DDE Execute to move external .txt file
My db imports .txt files from a local cloud. I would now like the .txt file to be moved to a folder within the same directory called Complete once the data has been imported.
I have tried using by the SendEvent and Send DDE Execute but so far cannot get the files to move.
I have two variables declared:
$datapath (c:\Local Cloud\Test)
I have tried "cmd.exe /c move $csvfile./$datapath&Complete"
but it doesnt work.
What am I doing wrong? Any help would be appreciated.
"cmd.exe /c move " & $csvfile & "./$datapath&Complete"
It's also possible to use a container field and export field contents to copy a file from one location to another.