Formatting Results so that They Can be Nicely Imported into a Spreadsheet.

[SMERSH009]

Hi All.
Let's say I have some badly formatted text called doc:


doc=
"""
friendid
Female

                            23 years old

                            Los Gatos

                            United States
friendid
Male

                            24 years old

                            San Francisco, California

                            United States
"""

How would I get these results to be displayed in a format similar to:
friendid;Female;23 years old;Los Gatos;United States
friendid;Male; 24 years old;San Francisco, California;United States


The latter is a lot easier to organize and can be quickly imported
into Excel's column format.

Thanks Much,
Sam

-- 
http://mail.python.org/mailman/listinfo/python-list