How to extract last name from a string

Question

I have SQL query that returns last name of a person and I need to extract the last part of any hyphenated or last names with a space in them

In cases where the person has one last name everything is OK

Like Smith. That OK. . I am looking for just Smith

The problem I have is when I have hyphenated last names like Scott-Thomas

In that case I want to extract the last last name or Thomas.

Or if I have a last name like Rodham Clinton.
In that case I only want to extract the last last name Clinton.

How do I do this?

Carl Von Stetten · Accepted Answer

Creative use of the ListLast() function. Something like:

Notice that the optional 2nd parameter, which is a non-default delimiter, has a space and a hyphen between the quotes. This will cause ListLast() to break a string containing either a space or a hyphen into multiple parts, and return only the last part.

-Carl V.

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded