Taxacom: Rather an informaticy question about botanical names

[Peter A Rauch]

Mary, Take a look at this explanation
<https://nam10.safelinks.protection.outlook.com/?url=https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Ftrim-function-410388fa-c5df-49c6-b16c-9e5630b479f9&data=05%7C01%7Ctaxacom%40lists.ku.edu%7C5e0fcc4f4d324d57fd6408da858b81d9%7C3c176536afe643f5b96636feabbe3c1a%7C0%7C0%7C637969131489293008%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=j4gVOD9MxAqElhymPIVwdtYmP%2B5PUFtyk0hNOynMEwQ%3D&reserved=0>
of how the TRIM function works (esp. "... except for single spaces between
words ..."), and the examples pointed to.
Peter

On Tue, Aug 23, 2022 at 8: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%7C5e0fcc4f4d324d57fd6408da858b81d9%7C3c176536afe643f5b96636feabbe3c1a%7C0%7C0%7C637969131489449281%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=C%2FUuwhr6FqQvwRRAzM0bvoJG8qGIwYiFBM0dER2g03Y%3D&reserved=0
>
> Nurturing nuance while assailing ambiguity for about 35 years, 1987-2022.
>