[Tutor] data from excel spreadsheet to csv and manipulate

[sacha rook]

Hi
 
can anyone help with the best way to tackle this?
 
I have a spreadsheet ms excel, that has a name column that I want to extract to csv and manipulate as follows.
 
The name column has data in this format
 
Name
 
Surname Firstname
 
after extracting and manipulating I want it to be as follows in three comma separated fields;
 
 
Firstname, Surname, Firstname Surname
 
So 
 
Smith John
 
becomes
 
John, Smith, John Smith
 
I hope I have explained myself.
 
I want to use python to do all this if sensible, so what is the best approach?
 
Many thanks
 
S 
_________________________________________________________________
Feel like a local wherever you go.
http://www.backofmyhand.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mail.python.org/pipermail/tutor/attachments/20071003/5fd9e162/attachment.htm