I'm trying to move files to a newly created folders but I'm getting "FileExistsError: [WinError 183] Cannot create a file when that file already exists":
This is part of my code:
#Creating year folder
year_folder = Path(working_path,year)
year_folder.mkdir(parents=True, exist_ok=True)
#Creating month folder
month_folder = Path(year_folder,month)
month_folder.mkdir(parents=True, exist_ok=True)
#Creating suffix folder
suffix_folder = Path(month_folder,doc.suffix.upper())
suffix_folder.mkdir(parents=True, exist_ok=True)
#Creating new file name
parent_folder = doc.parent.name
doc_name = doc.stem.replace(' ', '_')
cleaned_doc_name = re.sub("[^A-Za-z0-9]+",'', doc_name)
new_file_name = f'{date}_{parent_folder}_{cleaned_doc_name}{doc.suffix}'
#Rename and move file
doc.rename(Path(suffix_folder,new_file_name))
file.write(f'\n{Path(suffix_folder,new_file_name).as_posix()}')
Searching for answers I only came across people that was having the same issue because when they created the folder but I already tried using exist_ok=True when making the folder without luck. I'm no expert but it really seems it's the file it self. Is there a function to append an auto increment number the same way windows does if the file name already exist? Or what are my options.
