将文件移动到文件夹的Powershell脚本-如何从$newFolder中删除连字符



我有很多文件要根据文件名的第一部分归档到文件夹中。文件名->文件夹名由特定字符分隔:[-][、][和]。示例:

第一个文件名-2016-04.pdf第二个文件名和另一个名称.mp3Third.jpg第四文件名,2016.pdf

我希望得到的文件夹名称不包括[\s-][,\s][\sand\s]部分。

这是我的脚本,它很有效,只是文件夹名称中包含了我不想要的东西,例如:

第一个文件夹名称-第四个文件名,

认为这与我的正则表达式匹配贪婪地包含连字符(特别是)有关,但我不知道如何格式化查询和创建sunsequence文件夹名。

此外,用"####"(就像进度指示器)评论的东西也不起作用。如果你有任何建议,请发表评论。我根本不是一个程序员。

$OrigFolder = "."
$NewFolder = "._Sorted to Move"
# Orphans folder, where files that return null in the regex match will be moved
# Example: file "- title.mp4"
# will be moved to ".Sorted_Orphans" folder
$Orphans = '_Orphans' # Use the underscore to sort the folder to the top of the window
#### How to use an array of values for the delimiters in the regex instead of literals
#### My proposed code, but I am missing how o use the delims in the regex match
#### $delims = "s-s" ",s"s ands"
# First count the number of files in the $OrigFolder directory
$numFiles = (Get-ChildItem -Path $OrigFolder).Count
$i=0
# Tell the user what will happen
clear-host;
Write-Host 'This script will copy ' $numFiles ' files from ' $OrigFolder ' to _Sorted to Move'
# Ask user to confirm the copy operation
Read-host -prompt 'Press enter to start copying the files'
# Regex to match filenames
$Regex = [regex]"(^s*(.*?)s*-)|(^s*(.*?),)|(^s*(.*?)s*ands)"
    # Loop through the $OrigFolder directory, skipping folders
Get-ChildItem -LiteralPath $OrigFolder | Where-Object {!$_.PsIsContainer} |
    ForEach-Object {
        if($_.BaseName -match $Regex){
            #### Caluclate copy operation progress as a percentage
            #### [int]$percent = $i / $numFiles * 100
            # If first part of the file name is empty, move it to the '_Orphans' folder
            if(!$Matches[1]){
                $ChildPath = $Orphans
            } else {
                $ChildPath =  $Matches[1]
            }
# Generate new folder name
$FolderName = Join-Path -Path $NewFolder -ChildPath $ChildPath
# Create folder if it doesn't exist
    if(!(Test-Path -LiteralPath $FolderName -PathType Container)){
        $null = New-Item -Path $FolderName -ItemType Directory
    }
# Log progress to the screen
Write-Host "$($_.FullName) -> $FolderName"
# Move the file to the folder
            Move-Item -LiteralPath $_.FullName -Destination $FolderName
##### Tell the user how much has been moved
##### Write-Progress -Activity "Copying ... ($percent %)" -status $_  -PercentComplete $percent -verbose
##### $i++
    }
}
Write-Host 'Total number of files in '$OrigFolder ' is ' $numFiles
Write-Host 'Total number of files copied to '$NewFolder ' is ' $i
Read-host -prompt "Press enter to complete..."
clear-host;

感谢StackOverflow用户的帮助和我上面拼凑的代码片段。

以下正则表达式应该可以找到任何不需要的分隔符(使用非捕获组):

(?:s-)|(?:,s)|(?:sands)

这是演示

现在,您所要做的就是将-replace与正则表达式一起使用以消除它们:

if($_.BaseName -match $Regex)
{
    $ChildPath = $_.BaseName -replace $Regex
    # copy...
}

此外,请查看"写入进度"帮助:

如果没有显示进度条,请检查$ProgressPreference变量。如果该值被设置为SilentlyContinue,则不显示进度条。有关Windows的详细信息PowerShell首选项,请参阅about_Preference_Variables。参数的属性对应于ProgressRecord类的属性(System.Management.Automation.ProgressRecord)。有关详细信息,请参阅Windows PowerShell软件中的ProgressRecord主题开发工具包(SDK)。

这是将我的.pdf文件(杂志)移动到以杂志标题命名的子目录的完整脚本。感谢jisaak(Martin Brandl)帮助我解决正则表达式问题。将"杂志"添加到新文件夹的解决方案在第46/47行。对大多数人来说可能是显而易见的,但我花了一个小时才弄清楚。

我很喜欢关于简化代码和修复缩进等的建议。我还不知道Powershell的风格,这是我第一次尝试

$OrigFolder = "T:Magazines"
$NewFolder = "T:Magazines_Sorted to Move"
# Orphans folder, where files that return null in the regex match will be moved
# Example: file "- title.pdf"
# will be moved to ".Sorted_Orphans" folder
$Orphans = '_Orphans' # Use the underscore to sort the folder to the top of the window
#### How to use an array of values for the delimiters in the regex instead of literals
#### My proposed code, but I am missing how o use the delims in the regex match
#### $delims = "s-s" ",s"s ands"
# First count the number of files in the $OrigFolder directory
$numFiles = (Get-ChildItem -Path $OrigFolder).Count
$i=0
# Tell the user what will happen
clear-host;
Write-Host 'This script will copy ' $numFiles ' files from ' $OrigFolder ' to _Sorted to Move'
# Ask user to confirm the copy operation
Read-host -prompt 'Press enter to start copying the files'
# Regex to match filenames
$Regex = [regex]"(?:(.*?)s-)|(?:(.*?),s)|(?:(.*?)sands)"
# Loop through the $OrigFolder directory, skipping folders
Get-ChildItem -LiteralPath $OrigFolder | Where-Object {!$_.PsIsContainer} |
    ForEach-Object {
        if($_.BaseName -match $Regex){
        $ChildPath = $_.BaseName -replace $Regex
#Caluclate copy operation progress as a percentage
[int]$percent = $i / $numFiles * 100

# If first part of the file name is empty, move it to the '_Orphans' folder
if(!$Matches[1]){
    $ChildPath = $Orphans}
else {
    $ChildPath = $Matches[1]
    }

# Generate new folder name and append ' Magazine' to the new folder name
$FolderName = Join-Path -Path $NewFolder -ChildPath ($ChildPath + ' Magazine')
# Create folder if it doesn't exist
    if(!(Test-Path -LiteralPath $FolderName -PathType Container)){
    $null = New-Item -Path $FolderName -ItemType Directory}
# Log progress to the screen
Write-Host "$($_.FullName) -> $FolderName"
# Move the file to the folder
Move-Item -LiteralPath $_.FullName -Destination $FolderName
# Tell the user how much has been moved
Write-Progress -Activity "Copying ... ($percent %)" -status $_  -PercentComplete $percent -verbose
$i++
    }
}
Write-Host 'Total number of files in '$OrigFolder ' is ' $numFiles
Write-Host 'Total number of files copied to '$NewFolder ' is ' $i
Read-host -prompt "Press enter to complete..."
clear-host;

我已经修改了我的多媒体文件和图片的脚本,你不知道这会为我节省多少时间。再次感谢你,马丁!

最新更新