Skip to content
TheChatArchiveThe Chat Archive
gpt-3.5-turbo-0301· OpenAIAi2 WildChat-4.8M (AI2)

生成一段VBS代码将文件所在位置下的所有MP4文件按以下示例重命名: “11.第11.11.第11讲…

  1. User

    生成一段VBS代码将文件所在位置下的所有MP4文件按以下示例重命名: “11.第11.11.第11讲 配位化合物(Av542366173,P11).mp4”改为“11.配位化合物.mp4” “12.第12.12.第12讲 配合物(Av542366173,P12).mp4”改为“12.配合物.mp4” 从11到46

  2. Assistant

    Dim fso Set fso = CreateObject("Scripting.FileSystemObject") Dim folderPath folderPath = "C:\example\folder" Dim file For Each file In fso.GetFolder(folderPath).Files Dim fileName fileName = fso.GetBaseName(file.Name) Dim fileExtension fileExtension = fso.GetExtensionName(file.Name) If fileExtension = "mp4" Then If Left(fileName, 2) >= 11 And Left(fileName, 2) <= 46 Then Dim newFileName If InStr(fileName, "讲") > 0 Then newFileName = Left(fileName, 2) & ".配位化合物." & fileExtension Else newFileName = Left(fileName, 2) & ".配合物." & fileExtension End If fso.MoveFile file.Path, fso.BuildPath(fso.GetParentFolderName(file.Path), newFileName) End If End If Next MsgBox "Done"

  3. User

    生成一段VBS代码将文件所在位置下的所有MP4文件按以下示例重命名: “11.第11.11.第11讲 配位化合物(Av542366173,P11).mp4”改为“11.配位化合物.mp4” “12.第12.12.第12讲 配合物(Av542366173,P12).mp4”改为“12.配合物.mp4” 从11到46,重命名规则为去掉“第?讲”(?为文件名的前两个字符对应的数字),去掉倒数第21到倒数第5个字符

  4. Assistant

    Dim fso Set fso = CreateObject("Scripting.FileSystemObject") Dim folderPath folderPath = "C:\example\folder" Dim file For Each file In fso.GetFolder(folderPath).Files Dim fileName fileName = fso.GetBaseName(file.Name) Dim fileExtension fileExtension = fso.GetExtensionName(file.Name) If fileExtension = "mp4" Then If Left(fileName, 2) >= 11 And Left(fileName, 2) <= 46 Then Dim newFileName If InStr(fileName, "讲") > 0 Then newFileName = Left(fileName, 2) & "." & Replace(Mid(fileName, InStr(fileName, "讲") + 1, 2), ".", "") & "." & Replace(Mid(fileName, InStrRev(fileName, "(") - 3, 18), ".", "") & "." & fileExtension Else newFileName = Left(fileName, 2) & "." & Replace(Mid(fileName, InStr(fileName, "物") + 1, 2), ".", "") & "." & Replace(Mid(fileName, InStrRev(fileName, "(") - 3, 18), ".", "") & "." & fileExtension End If fso.MoveFile file.Path, fso.BuildPath(fso.GetParentFolderName(file.Path), newFileName) End If End If Next MsgBox "Done"

  5. User

    生成一段VBS代码将文件所在位置下的所有MP4文件按以下规则重命名: 重命名规则为去掉第4到第14个字符,去掉倒数第21到倒数第5个字符

  6. Assistant

    Dim fso Set fso = CreateObject("Scripting.FileSystemObject") Dim folderPath folderPath = "C:\example\folder" Dim file For Each file In fso.GetFolder(folderPath).Files Dim fileName fileName = fso.GetBaseName(file.Name) Dim fileExtension fileExtension = fso.GetExtensionName(file.Name) If fileExtension = "mp4" Then Dim newFileName newFileName = Left(fileName, 3) & Right(fileName, 4) & "." & fileExtension fso.MoveFile file.Path, fso.BuildPath(fso.GetParentFolderName(file.Path), newFileName) End If Next MsgBox "Done"

Responses were produced in different, uncontrolled contexts (system prompts, settings, prior turns). This is not a benchmark.