Forum Discussion

TroyMacPherson's avatar
TroyMacPherson
Qrew Cadet
3 years ago

Formula to pull Last name from a full name field accounting for jr, sr, II, etc.

Hi QB users, I have a QB with a simple formula that pulls the last name from a [Full Name] field, which works most of the time except for suffixes like Sr., Jr. II, etc. Current formula: Right(...
Formulas and functions
rbuschmeyer's avatar
rbuschmeyer
Qrew Trainee
3 years ago
So an interesting question is "what is the nature of input" of the Full Name field?  Is that a user-input field?  If so, (and if it is possible in your scenario), it might be easier to normalize the data through a different user-input strategy (e.g. different fields for each name component). 

Seems the parsing of the last name could be extremely problematic given you could have several different styles of ethnic naming.

Sorry if I'm not providing an acceptable solution...just some thoughts.

------------------------------
Ryan Buschmeyer
------------------------------
JeffPeterson1's avatar
JeffPeterson1
Qrew Captain
3 years ago
That's what I was thinking also.   This is why on many forms,  first, last, middle and suffix are separate fields.

------------------------------
Jeff Peterson
------------------------------