I'm having trouble formatting text from a .txt file, into a grid.

[Connor Bergman]

Im trying to create a bank statement basically, and Im having trouble formatting the output to a grid, from a .txt file. And I wrote the file, and can read the first line, and want to pull the date out, and seperate the amount. And with the following lines say the date, type of transaction, the location, amount of the transaction, and finally the running total.

here is what I'm looking to achieve with this:(with all the numbers and columns lining up with plenty of space for the characters.)

03/15/11 Beginning Balance 1000.00
03/15/11 Check Hugos 25.00 975.00
03/15/11 Deposit UND 500.00 1475.00


Here is my WORKING code so far

 
# Writing the file to begin with, I just hard coded it to skip to good stuff#
f = open("acct.txt", 'w')
f.write ("03/15/11, 1000.00\n")
f.write ("03/15/11, C, Hugos, 25.00\n")
f.write ("03/15/11, D, UND, 500.00")
f.close()
 
# first line #
g = open("acct.txt", 'r')
q = g.readline()
for date in q:
    D = q.replace(","," ")
    D = q.replace("\n","") 
 
 
    print D[0:d]
g.close()

any ideas to continue this would be extremely helpful, I am a newby to this, and simpler the better would be awesome!

Thanks guys

[Mariostg]

You can improve this. Look at Fancier Output Formatting