Forum Discussion

JeffElliott's avatar
JeffElliott
Qrew Member
5 years ago

Left function - more than one word separated by space

I have used the "left" function identifying the space after the first word as " ".... to give me the first name in a text field.  So, if it is "Jane doe" then I get "Jane". If there are three names...
Formulas and functions
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
5 years ago
If you want everything except the last name, then you can use

NotRight([my name field]," ")

That will work for any number of names.  So the last name would be

Right([my name field]," ") and everything else would be the first formula

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------