What is the business case for this separation? For all practical purposes keeping the name as a single string is best. A better solution to your problem may be changing anything that expects parts to expect a single combined name instead, which would then work for names of any nationality. -- Darren Duncan

On 2020-02-27 1:43 p.m., 'anotherhoward' via BBEdit Talk wrote:
I have a list of names in this format:

Luis Gonzalez\gonzalu01
Eddie Perez\perezed02
B.J. Surhoff\surhob.01
Bobby Bonilla\bonilbo01
Keith Lockhart\lockhke01

I want to extract the last names and separately extract what comes before each last name (which could be just the first name or two initials as in "B.J.") so that I can later organize them this way:

*First       Last*
Luis        Gonzalez
Eddie      Eddie
B.J.         Surhoff
Bobby     Bobby
Keith       Lockhart

I do not need the data after the slash.

How can I use GREF (REGEX) to extract the last names and separately the first/middle values?

--
This is the BBEdit Talk public discussion group. If you have a feature request or need 
technical support, please email "supp...@barebones.com" rather than posting here. 
Follow @bbedit on Twitter: <https://twitter.com/bbedit>
--- You received this message because you are subscribed to the Google Groups "BBEdit Talk" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to bbedit+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/bbedit/824baf58-2866-65dd-2e2c-46844671b516%40darrenduncan.net.

Reply via email to