On 7/12/2012 9:06 AM susana moreno colomer said...
Hi!
This code is working fine!
The only one little thing is that the 6 columns appear together in one
column, what means, in eac cell I get 6 numbers. How can I get tit in 6
excel columns?
You're creating a list (output) with only one column in it, so you only
get one column in excel.
Try making these chages (untested):
outfile=open('myfile1', 'w')
cols=[] # this will get one list (column) per found file
for infile in files:
if fnmatch.fnmatch(infile, 'bb_*'):
thiscol = [] # we're starting a new file so start a new column
filename= os.path.join(path,infile)
f=open(filename, 'r')
for line in f:
b=line.split('\t')
thiscol.append(b[5].strip()) # append each col value
f.close()
cols.append(thiscol) # store this cols results
output = zip(cols) # zip transposes the cols to rows
HTH,
Emile
_______________________________________________
Tutor maillist - Tutor@python.org
To unsubscribe or change subscription options:
http://mail.python.org/mailman/listinfo/tutor
