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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20

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:

1 2 3 4 5 6 7 8 9 10 11 12 13 14

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