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)