Pull First Name from Full Name
Easy one (hopefully). I have field "Name" (ex. John Smith). I want to pull just "John". What's the calculation?
This will work, providing there is always a space or punctuation charactre between first and last names.
And providing the first name is only one 'word'.
For example, Mary Lou Jones would be Mary and Billy-Bob Thornton would be Billy.
Retrieving data ...