_renamer.py 1.8 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061
  1. import os
  2. import re
  3. # bt_files = filter(lambda f: 'BTRL' and '.csv' in f, os.listdir())
  4. # bacx_files = filter(lambda f: 'export' in f, os.listdir())
  5. def rename_bt(bt_files=None):
  6. bt_files = bt_files or filter(lambda f: 'BTRL' and '.csv' in f, os.listdir())
  7. for file in bt_files:
  8. idx = re.search('-[0-9]+.[0-9]+.[0-9]+-[0-9]+.[0-9]+.[0-9]+', file)
  9. if idx:
  10. print(idx)
  11. ext = file[-4:]
  12. loc = idx.start()
  13. # os.rename(file, file[:loc] + ext)
  14. os.replace(file, file[:loc] + ext)
  15. print(file)
  16. def rename_bacx(bacx_files=None):
  17. bacx_files = bacx_files or filter(lambda f: 'export' in f, os.listdir())
  18. for file in bacx_files:
  19. idx = re.search(' \(', file)
  20. if idx:
  21. print(idx)
  22. ext = file[-4:]
  23. loc = idx.start()
  24. # os.rename(file, file[:loc] + ext)
  25. os.replace(file, file[:loc] + ext)
  26. print(file)
  27. def delete_bacx(io1, io2, io3):
  28. ops = []
  29. with open(io1) as log:
  30. for row in log.readlines():
  31. ops.append(row[2:])
  32. with open(io2) as bacx_export:
  33. lines = bacx_export.readlines()
  34. with open(io3, 'w') as export2:
  35. for line in lines:
  36. if line not in ops:
  37. export2.write(line)
  38. def delete_btrl(io1, io2, io3):
  39. ops = []
  40. with open(io1) as log:
  41. for row in log.readlines():
  42. row = row[2:].replace('"', '')
  43. ops.append(row)
  44. # print(row)
  45. with open(io2) as btrl_export:
  46. lines = btrl_export.readlines()
  47. with open(io3, 'w') as export2:
  48. for line in lines:
  49. line2 = line.replace('"', '')
  50. if line2 not in ops:
  51. export2.write(line)
  52. if __name__ == '__main__':
  53. rename_bt()
  54. rename_bacx()