Removing suffixes from the name

Question

I have a requirement to remove the suffix from the name field. For example the values in the field can contain suffixes such as JR, SR, II, III, IV

current value                                 New Value
HENRY ANDERSON IV                HENRY ANDERSON
MACK STOVER III                        MACK STOVER
JOHN JOSEPH LAWLER III         JOHN JOSEPH LAWLER
JEFFREY D KIRKLAND JR         JEFFREY D KIRKLAND

The suffix will always be in the end trailing a space. What calc can I leverage to accomplish this? Thanks for your help in advance.

atcodedog05 · Accepted Answer

Hi @Idyllic_Data_Geek

Here is how you can do it.

Workflow:

Hope this helps : )

amruthas2 · Accepted Answer

@Idyllic_Data_Geek

You could directly use a formula for the expected output

Left([Names],FindString(
REGEX_Replace([Names], "(.*) (.*)", '$1*$2')
,"*"))