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
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 My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> batrouney.topofthecap@gmail.com wrote: > 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
