Advertisement
Guest User

Untitled

a guest
Nov 20th, 2017
70
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.99 KB | None | 0 0
  1. import os
  2. file_to_read = "file.txt"
  3. separator = "@"
  4. try:
  5. os.remove("newfile.csv")
  6. os.remove("errorlog.txt")
  7. except FileNotFoundError:
  8. pass
  9.  
  10. with open(file_to_read, "r") as r:
  11. with open ("newfile.csv", "a") as w:
  12. for l in r:
  13. try:
  14. w.write("{0}{separator}{1}{separator}{2}{separator}{3}{separator}{4}{separator}{5}{separator}{6}{separator}{7}{separator}{8}{separator}{9}{separator}{10}{separator}{11}{separator}{12}{separator}{13}{separator}{14}{separator}{15}{separator}{16}{separator}{17}{separator}{18}\n".format(l[:14].strip(),l[14:75].strip(),l[75:79].strip(),l[79:83].strip(),l[83:88].strip(),l[88:93].strip(),l[93:108].strip(),l[108:112].strip(),l[112:118].strip(),l[118:122].strip(),l[122:125].strip(),l[125:131].strip(),l[131:135].strip(),l[135:138].strip(),l[138:144].strip(),l[144:148].strip(),l[148:151].strip(),l[151:157].strip(),l[157:].strip(),separator=separator))
  15. except Exception as e:
  16. with open ("errorlog.txt", "a") as log:
  17. log.write("{};;{}".format(l, e))
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement