I'm totally new to PowerShell, so bear with me….I have 3 books to read.
I have a daily task that I would like to automate with a script and then use Windows Task Scheduler to run it. I copy and rename 6 files on a network drive, then move the files with the new names to an ftp directory.
1) On my local PC I go to a network drive, and make a copy of 6 files (file name changes daily).
2) Then I rename the files to a standard naming convention for each of the 6 files. The original filename will be something like ABC_FILE_2012-C1630_01-18-12.xls and the new file name will be filename_x_c#.xls where '#' is replaced by the number following 'C' in the original file. ie, ABC_FILE_2012-C1630_01-18-12.xls becomes filename_x_c1630.xls.
3) Copy the 6 renamed files to an ftp server (with specific userid/pw) directory.
4) Need to Create a Windows Sheduled Task to run this script daily.
Can someone provide an outline of the PS script that I would need to do this?
TIA,
Don