blob: 69e1d8713e5d292dac1056b013026d4c463b105d (
plain) (
blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
|
#!/usr/bin/python
# this formats a csv file to a serious whitespace intended format.
import os
import sys
tabs=not True
fname = sys.argv[1]
if not os.path.exists(fname):
print "that file doesn't exist"
exit(0);
f=open(fname,"r");
lines=f.readlines()
f.close();
length=0
for line in lines:
length=max(length, len(line.split(",")))
print "# number of entries =",length
additionalspaces = 5
#setup text array
textarray=range(len(lines)+1)
for x in range(len(lines)+1):
textarray[x] = range(length)
for x in range(length):
textarray[-1][x] = 0
#find the longest entry in each line in each position
for lineno in range(len(lines)):
sp=lines[lineno].split(",")
for pieceno in range(len(sp)):
sp[pieceno] = sp[pieceno].strip()
textarray[-1][pieceno] = max(len(sp[pieceno]),textarray[-1][pieceno])
if tabs:
#make it divisable by 8 (tabs work then)
for pieceno in range(length):
if textarray[-1][pieceno] %8:
textarray[-1][pieceno] = ((textarray[-1][pieceno]/8) *8) +8
for lineno in range(len(lines)):
sp=lines[lineno].split(",")
for pieceno in range(length):
textarray[lineno][pieceno] = ""
if pieceno<len(sp):
sp[pieceno]= sp[pieceno].strip()
if pieceno<len(sp)-1:
sp[pieceno]= sp[pieceno] + ","
n=(textarray[-1][pieceno]-len(sp[pieceno])+additionalspaces)
if (tabs):
textarray[lineno][pieceno] = sp[pieceno]
textarray[lineno][pieceno] += "\t" *(n/8)
else:
textarray[lineno][pieceno] = " "*(n) + sp[pieceno]
fname = sys.argv[2]
if not os.path.exists(fname):
print "that file doesn't exist"
exit(0);
else:
f=open(fname,"w");
for line in textarray[:-1]:
for piece in line:
f.write(piece)
f.write("\n")
f.close()
|
