Jul 16, 2017 12:04 PM
The question of how to extract the last name from a combined “first [middle][…] last [suffix]” name string – or the last word from a multi-word string – comes up from time to time. I offer a solution (with caveats) in a reply to a recent support post. My example is name-oriented but could easily be adapted to an arbitrary string. Hope this will save someone some time!
Nov 16, 2021 06:05 PM
Welcome to the community, @Margaret_Pickering1! :grinning_face_with_big_eyes: For what it’s worth, the solution above is several years old. There are more efficient ways of doing this using regular expressions. Extracting the last word of a string can be done with this formula:
IF(Name, REGEX_EXTRACT(Name, "[^ ]*$"))
Nov 23, 2021 12:37 PM
Thanks, that is helpful