使用Python批量重命名TXT文件（文件已存在报错）及实现方案咨询

Hey there, let's break down why your code is throwing that "Cannot create a file when that file already exists" error and fix it properly for your renaming needs.

为什么你的现有代码会报错？ #

• 首先，file_name[-5:5] is totally incorrect slice syntax in Python: slicing works as [start:end], so this line would generate an empty string or invalid filename. This invalid naming logic is likely causing conflicts with existing files, triggering the error.
• Most importantly, your code doesn't implement the renaming rule you described at all—it doesn't extract the prefix, nor does it convert the trailing number to the corresponding letter.

正确的实现方案 #

We'll build the solution step by step to match your exact requirement:

1. Parse each TXT filename to split out the prefix (e.g., Receipt ABC-001) and the trailing sequence number (e.g., 1, 2)
2. Map the sequence number to its corresponding uppercase letter (1→A, 2→B, ..., 5→E)
3. Generate a valid new filename and avoid conflicts
4. Safely execute the rename operation

完整可运行代码 #

import os
import re

# Set target directory (use raw string to avoid escape character issues)
file_path = r"C:\Users\Mr.Slowbro\Desktop\TBU\\"

# Loop through all TXT files in the directory
for filename in os.listdir(file_path):
    if filename.endswith(".txt"):
        # Use regex to match your filename structure: [prefix] [random-numbers]-[sequence].txt
        match = re.match(r"(.*?)\s+\d+-(\d)\.txt", filename)
        if match:
            prefix = match.group(1)  # Extract prefix like "Receipt ABC-001"
            sequence_num = int(match.group(2))  # Extract trailing number like 1 or 2
            
            # Convert number to corresponding uppercase letter (1→A, 2→B...)
            # ASCII code for 'A' is 65, so 64 + num gives the right character
            if 1 <= sequence_num <= 5:  # Only handle 1-5 as per your requirement
                letter = chr(64 + sequence_num)
                new_filename = f"{prefix}{letter}.txt"
                old_file_full = os.path.join(file_path, filename)
                new_file_full = os.path.join(file_path, new_filename)
                
                # Check if new file exists to avoid conflict errors
                if not os.path.exists(new_file_full):
                    os.rename(old_file_full, new_file_full)
                    print(f"Renamed successfully: {filename} → {new_filename}")
                else:
                    print(f"Skipped: {new_filename} already exists")
            else:
                print(f"Skipped: {filename} has an invalid sequence number (not 1-5)")
        else:
            print(f"Skipped: {filename} doesn't match the expected filename format")

代码细节说明 #

• Regex Matching: The pattern (.*?)\s+\d+-(\d)\.txt is tailored to your filename structure:
  • (.*?): Greedily captures the prefix until the first space
  • \s+\d+-: Matches the space, random numbers, and hyphen (e.g., 623572349-)
  • (\d): Captures the single trailing sequence number
  • \.txt: Matches the file extension
• Letter Mapping: chr(64 + sequence_num) converts numbers to letters cleanly—no messy if-else chains needed
• Safety Check: We verify if the new filename already exists before renaming to avoid the error you encountered
• Raw String: Using r"C:\..." simplifies directory paths by eliminating the need for double backslashes

额外实用提示 #

• Test the regex matching first by printing match results if you're unsure about covering all your files
• Always back up your files before running bulk rename operations to prevent data loss
• If you need to handle numbers beyond 5, just expand the 1 <= sequence_num <=5 range (up to 26 for Z)

内容的提问来源于stack exchange，提问作者Mr.Slowbro