delete all files which contains word sql_Table1

[mg24]

Hi Team,

how to delete below files from a folder
which contains word sql_Table1


sql_Table1.csv
sql_Table1.gzip
Chksum_sql_Table1_20220806

import os
import os.path

def dbs_remove(folderpath,table)

	file = f'{tbl}.csv'
	fname = os.path.join(folderpath,tbl)
	print(file)

	if os.path.exists(fname):
		os.remove(fname)
	else:
		print('Path not found')



if __name__ == "__main__":
	#tbl = "sql_Table1"
	tbl = input("Enter TableName")
	folderpath = "E:\\test\reports"

Yoriz write Sep-15-2022, 11:57 AM:
Please post all code, output and errors (in their entirety) between their respective tags. Refer to BBCode help topic on how to post. Use the "Preview Post" button to make sure the code is presented as you expect before hitting the "Post Reply/Thread" button.

[DeaD_EyE]

Use pathlib:

from pathlib import Path


def remove_files(root, pattern):
    for element in Path(root).rglob(pattern):
        if element.is_file():
            element.unlink()


if __name__ == "__main__":
    tbl = "*sql_Table1*"
    # using the wildcard for rglob()
    folderpath = "E:\\test\reports"
    remove_files(folderpath, tbl)

[mg24]

Hi DeaD_EyE,

Superb ! your code is working as expected ! thanks for your help.



Thanks
mg