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
_______________________________________________
Tutor maillist  -  Tutor@python.org
http://mail.python.org/mailman/listinfo/tutor

Reply via email to