按文件名重命名报告

Question

我正在编写一个脚本来重命名报告并将它们放在文件夹中。

报表名称必须更改为正确的日期(日期必须在文件名中)。

例如，我有一个名为“Report_2015_02”的报告/我必须从文件名中减去一个月--而不是system 。

本例中的新报表名称需要为"Report_2015_01“。

但是目前我使用的是系统时间，所以报告名应该是"Report_2017_02“，因为systemtime (2017_03)减去一个月是2017_02.

Q:如何使用文件名的日期而不是系统时间？

这是我的密码：

#today's date (year-month-day)
$todaydate = Get-Date -Format yyyy-MM-dd

#arrays  (today => systemtime)
$todaydate = $todaydate.Split('-')
$todaydate[0] #year
$todaydate[1] #month
$todaydate[2] #day

#arrays yesterday (systemtime - one day)
$yesterdaysdate = Get-Date((Get-Date).AddDays(-1)) -Format yyyy-MM-dd
$yesterdaysdate = $yesterdaysdate.Split('-')
$yesterdaysdate[0] #year
$yesterdaysdate[1] #month
$yesterdaysdate[2] #day

#arrays yesterday (systemtime - one day)
$lastmonth = Get-Date((Get-Date).AddMonths(-1)) -Format yyyy-MM-dd
$lastmonth = $lastmonth.Split('-')
$lastmonth[0] #year
$lastmonth[1] #month
$lastmonth[2] #day

#Example 1:  Filename "Report_Telephone_yyyy-mm" => in this case "Report_Telephone_2016-12"
#it renames the file -> minus one month, so the name must be "Report_Telephone_2016-11"
$filename='Report_Telephone_'+ $lastmonth[0]+'-'+ $lastmonth[1] + '.xlsx'

write-host $filename
rename-item 'c:\Reporting\Report_Telephone_' + $todaydate[0] +'-' + $todaydate[1] + '.xlsx' -NewName $filename

$sourcepath='C:\Reporting\'+ $filename
write-host $sourcepath
$destinationpath='C:\Reporting\'+ $lastmonth[0]+'\'+ $lastmonth[1]
write-host $destinationpath
if(test-path $destinationpath)
{

} 
else 
{
     mkdir $destinationpath
}
move-item -path $sourcepath -destination $destinationpath



#Example 2:  Filename "Report_Outlook_yyyy-mm-dd" => in this case "Report_Outlook_2016-12-14"
#it renames the file -> minus one day, so the name must be "Report_Outlook_2016-12-13"

$filename='Report_Outlook_'+ $lastmonth[0]+'-'+ $lastmonth[1] + '.xlsx'

write-host $filename
rename-item 'c:\Reporting\Report_Outlook_' + $todaydate[0] +'-' + $todaydate[1] + '.xlsx' -NewName $filename

$sourcepath='C:\Reporting\'+ $filename
write-host $sourcepath
$destinationpath='C:\Reporting\'+ $yesterdaysdate[0]+'\'+ $yesterdaysdate[1]
write-host $destinationpath
if(test-path $destinationpath)
{

} 
else 
{
   mkdir $destinationpath
}
move-item -path $sourcepath -destination $destinationpath



#that is just for generating log-files
[System.IO.File]::WriteAllText("$sourcepath\Protokoll_$todaydate.xls", $output)

Answer 1

您可以使用简单的正则表达式获取月份，将其转换为整数，减法1，最后将其格式化为包含两个小数的字符串：

$fileName = 'Report_2015_02' # Probably want to use Get-ChildItem here...
$fileMonth = [int][regex]::Match($fileName, '\w+_\d+_(\d+)').Groups[1].Value
$fileMonth = "{0:D2}" -f ($fileMonth - 1)