Taxacom: Rather an informaticy question about botanical names

[Tony Rees]

Hi Mary, if you care to send me the spreadsheet I can take a look if you
like.

tonyrees49 at gmail.com

On Wed, 24 Aug 2022, 1:54 pm Mary Barkworth via Taxacom, <
taxacom at lists.ku.edu> wrote:

> A student has sent me a spreadsheet for uploading. One column is of names.
> He had them all linked to IPNI and they include the authors of the name. I
> need to strip the authors off. They are all at species rank, meaning I just
> need the first two words. Using Excel, I have removed the hyperlinks. Then
> I try to use the formula =TRIM(LEFT(d2, FIND("^",SUBSTITUTE(d2, " ",
> "^",2)&"^"))) to generate the pure binomial. It does not work. It does work
> if I manually delete the space between the name and the authors and then
> enter a space. Apparently, there is a hidden character linking the name to
> the authors.
>
> Here are a few of the entries that I am trying to fix.
> Arisaema jacquemontii Blume,
> Arisaema jacquemontii Blume,
> Arisaema jacquemontii Blume,
> Arisaema utile Hook.
> Arisaema utile Hook.
>
> Could someone help please? I tried exporting to a csv file, opening it in
> Notepad++ and then reexporting to Excel, but it did not work.
>
> Mary
> _______________________________________________
> Taxacom Mailing List
>
> Send Taxacom mailing list submissions to: taxacom at lists.ku.edu
> For list information; to subscribe or unsubscribe, visit:
> https://lists.ku.edu/listinfo/taxacom
> You can reach the person managing the list at: taxacom-owner at lists.ku.edu
> The Taxacom email archive back to 1992 can be searched at:
> https://nam10.safelinks.protection.outlook.com/?url=https%3A%2F%2Ftaxacom.markmail.org%2F&data=05%7C01%7Ctaxacom%40lists.ku.edu%7Cc2ef3be414fd4c6f26e408da85861d4c%7C3c176536afe643f5b96636feabbe3c1a%7C0%7C0%7C637969108309243455%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=vmegfh9s%2BnbqGW2JUsVjdnj5%2FHl8novFBqJZ2AX4X5w%3D&reserved=0
>
> Nurturing nuance while assailing ambiguity for about 35 years, 1987-2022.
>