Word Macro to Format Research Data

[batrouney.topofthecap]

Hello all, I seem to have gotten to the point on a project that I must
ask for a little help from my peers! I've only recently realized the
benefit to be had from using macros, so please no pointing AND
laughing; either point OR laugh.

I need to get

OS Schizosaccharomyces pombe (Fission yeast).
OC Eukaryota; Fungi; Dikarya; Ascomycota; Taphrinomycotina;
OC Schizosaccharomycetes; Schizosaccharomycetales;
OC Schizosaccharomycetaceae; Schizosaccharomyces.
OX NCBI_TaxID=4896;

turned into

Eukaryota
Fungi
Dikarya
Ascomycota
Taphrinomycotina
Schizosaccaromycetes
Schizosaccharomycetales
Schizosaccharomycetaceae
Schizosaccharomyces
Schizosaccharomyces pombe -> Fission yeast

There are several thousand of these entries and there is simply no way
that I can do this by hand. Just getting the text into the above
starting format took weeks of running macros *click click click* while
I read a book.

Even just some input as to the type of functions I might need in order
to do this. I feel like there might be a fair bit of conditional
branching?

Thanks,
topofthecap

 

[Graham Mayor]

No pointing or laughing, but your second list does not bear enough
relationship to the first for us to see *eaxactly* what principles you need
to apply to the former to get to the latter.

Eg your line beginning OS is at the start of the first list, but at the end
of the second list. The item beginning OX is missing entirely from your
second list. The rest appear to be split and tabbed at the commas but are
not in any logical sort order in the second list and all the lines have lost
their two start letters the commas and and the semi colon. The left bracket
appears to have been changed for -> and the right bracket eliminated....
and there are several thousand pages which may or may not in some way
resemble this short extract.

A macro would have to follow some logical steps that apply throughout. You
will need to explain all the criteria that apply to all the data in order
for anyone to come up with a method to format the document in the manner you
have started to set out.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>