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

[mensanator at aol.com]

On Aug 4, 6:35?pm, SMERSH009 <SMERSH0... at gmail.com> wrote:
> 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

d = doc.split('\n')

f = [i.split() for i in d if i]

g = [' '.join(i) for i in f]

rec = []
temprec = []
for i in g:
    if i:
        if i == 'friendid':
            rec.append(temprec)
            temprec = [i]
        else:
            temprec.append(i)
rec.append(temprec)

output = [';'.join(i) for i in rec if i]

for i in output: print i

##    friendid;Female;23 years old;Los Gatos;United States
##    friendid;Male;24 years old;San Francisco, California;United
States