How confident are you in your data source that you will always have names in the format of "string with no spaces" "space" "string with no spaces"?
Will you ever have names like: Jamie Lee Curtis (space in the "first" names) Onne van der Wal (space in the surname) or other variants? The expression will depend on your answer to that question. --Kerri On Thu, Feb 27, 2020 at 4:44 PM 'anotherhoward' via BBEdit Talk < bbedit@googlegroups.com> 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/59705c02-51c1-40da-ac1f-dda43d3f0d8c%40googlegroups.com > <https://groups.google.com/d/msgid/bbedit/59705c02-51c1-40da-ac1f-dda43d3f0d8c%40googlegroups.com?utm_medium=email&utm_source=footer> > . > -- 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/CAEmA4ubWJy31aSav4xLnusSLdxZFmVscJLs1zVj-o9Va-DiuCQ%40mail.gmail.com.
