[Tutor] get columns from txt file

[Prasad, Ramit]

Please always reply to the list!

> 
> Hi!
> I am sorry, but still I don't get it!
> I am trying with this (the code is attached)
> 
> csv_out=csv.writer(open('out1.csv', 'wb'), delimiter=' ',
> quoting=csv.QUOTE_ALL, dialect='excel')
> and
> csv_out=csv.writer(open('out1.csv', 'wb'), dialect='excel-tab')
> 
> When I open out1 with text editor, I get 6 columns, but when I open it with
> excel I get one column (6 numbers on each cell, how can I separate it it???)
> 
> The files from wich I get the columns are txt files.
> 
> Many thanks!!

Use
csv_out=csv.writer(open('out1.csv', 'wb'), dialect='excel')
NOT dialect 'excel-tab' or with the delimiter field.

Alternatively try following these steps,
http://www.ehow.com/how_4449036_import-delimited-file-excel.html



Ramit


Ramit Prasad | JPMorgan Chase Investment Bank | Currencies Technology
712 Main Street | Houston, TX 77002
work phone: 713 - 216 - 5423

This email is confidential and subject to important disclaimers and
conditions including on offers for the purchase or sale of
securities, accuracy and completeness of information, viruses,
confidentiality, legal privilege, and legal entity disclaimers,
available at http://www.jpmorgan.com/pages/disclosures/email.