import os

rootdir = '/home/jwood13/svns/wisp/var/jwood/lisp101/ml/data'
# rootdir = os.getcwd()

def del3(afile):
    afile1 = "data/" + afile
    infile = open(afile1, "r")
    tblname = afile[0:(len(afile)-4)]
    afile2 =  "dataC/" + tblname + ".lisp"
    flg = True
    try:
	outfile = open(afile2, "w")
    except IOError:
	print ("Error: You lack permission to write files here\n")
	exit()

    for line in infile:
        curline = line.split(',')
        del curline[0:3]
        if flg:
            i = 0
            for cell in curline:
                if (cell[0:(len(cell)-2)] == "bug"):
                    curline[i] = "!" + curline[i]
                else:
                    curline[i] = "$" + curline[i]
                i += 1
            outfile.write("(deftable ")
            outfile.write(tblname)
            outfile.write(" ")
        else:
            outfile.write("(! ")
        tmp = ' '.join(curline)
        outfile.write(tmp[0:(len(tmp)-2)])
        outfile.write(")")
        outfile.write("\n")
        flg = False	
    outfile.write("\n\n")
    outfile.close()               
                
print ("Test......")
print (os.getcwd())

for subdir, dirs, files in os.walk(rootdir):
    for afile in files:
        print (afile)
        del3 (afile)