Skip to content

Instantly share code, notes, and snippets.

@Tokugero
Created April 12, 2018 17:16
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save Tokugero/75f29a9594809bca96b30e387528d2db to your computer and use it in GitHub Desktop.
Save Tokugero/75f29a9594809bca96b30e387528d2db to your computer and use it in GitHub Desktop.
import csv
import os
import re
# Put this code inside the directory you want to fix tabs
spaces1 = " "
spaces2 = " "
spaces3 = " "
spaces4 = " "
spaces5 = " "
spaces6 = " "
spaces7 = " "
spaces8 = " "
spaces9 = " "
spaces10 = " "
spaces11 = " "
spaces12 = " "
spaces13 = " "
spaces14 = " "
spaces15 = " " #15
DIR = "C:/Users/5167/Documents/ECRMC-Projects/DHCP-Review/log/raw/"
file_list = []
for root, dirs, files in os.walk(DIR):
for name in files:
path = os.path.join(root, name)
if name != _file_:
file_list.append(path)
for file_path in file_list:
file = open(file_path, 'r')
content = file.read()
content = content.replace(spaces15, "\t")
content = content.replace(spaces14, "\t")
content = content.replace(spaces13, "\t")
content = content.replace(spaces12, "\t")
content = content.replace(spaces11, "\t")
content = content.replace(spaces10, "\t")
content = content.replace(spaces9, "\t")
content = content.replace(spaces8, "\t")
content = content.replace(spaces7, "\t")
content = content.replace(spaces6, "\t")
content = content.replace(spaces5, "\t")
content = content.replace(spaces4, "\t")
content = content.replace(spaces3, "\t")
content = content.replace(spaces2, "\t")
content = content.replace(spaces1, "\t")
contentObject = content.split(' ')
print contentObject
newContentObject = []
for item in contentObject:
if item:
newContentObject.append(item)
print newContentObject
file.close()
file = open(file_path, 'w')
file.write(content)
txt_file = r"C:/Users/5167/Documents/ECRMC-Projects/DHCP-Review/log/raw/myshittyoutput.txt"
csv_file = r"C:/Users/5167/Documents/ECRMC-Projects/DHCP-Review/log/csv/myshittycsv.csv"
in_txt = csv.reader(open(txt_file, "rb"), delimiter = '\t')
out_csv = csv.writer(open(csv_file, 'wb'))
out_csv.writerows(in_txt)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment