On Mon, 29 Dec 2008 13:18:55 -0700 "Eduardo Vieira" <eduardo.su...@gmail.com> wrote:
> Hello, this weekend I had fun using Python for text processing. I > needed to change a qif converted from a ofx, using the tool MT2OFX > (http://www.xs4all.nl/~csmale/mt2ofx/en/index.htm) > I wanted to change transactions like these: > D11/14/2008 > MCHEQUE 102 17590807;Cheque or Preauth. Debit > T-500.00 > N102 > ^ > > Into this: > D11/14/2008 > MCHEQUE 102 17590807;Cheque or Preauth. Debit > T-500.00 > N102 > PLorne Koehn > LHousing:Rent > > == That is, insert those given Payee and Category if the transaction > was a cheque of 500.00 > > I came up with these two versions and would like to know which should > be more efficient or practical. Could you point improvements? > VERSION ONE: > f = open('cibc.QIF', 'r').readlines() > for line in range(len(f)): > if f[line] == 'T-500.00\n': > f[line+1] += 'PLorne Koehn\nLHousing:Rent\n' > > new = open('cibc.QIF', 'w') > new.writelines(f) > I would change 'line' --> 'line_nr' or 'lineno' or for line,index in enumerate(f) no! for index,line in enumerate(f) ;-) > VERSION TWO: > f = open('cibc.QIF', 'rw') > g = open('newresult.qif', 'w') > flag = 0 > for line in f: > if line == 'T-500.00\n': > flag = 1 > elif line.startswith('N') and flag: > flag = 0 > line += 'PLorne Koehn\nLHousing:Rent\n' > > g.write(line) > > f.close() > > #====== > > One thing like about version 1 is that I can overwrite the same > file, and don't need to create another one. I haven't figured out how > to do the same with the second version and overcoming the IOError. maybe by first writing on a string instead directly to a file -- then flush the whole text to the same file: text = "" # replaces g ... text += line ... f = open('cibc.QIF', 'w') f.write(text) > Thanks for your attention > > Edu > _______________________________________________ > Tutor maillist - Tutor@python.org > http://mail.python.org/mailman/listinfo/tutor > ------ la vida e estranya _______________________________________________ Tutor maillist - Tutor@python.org http://mail.python.org/mailman/listinfo/tutor
