Hi everybody,
I've got a formula I have been working on to parse out the last name in a text field; the formula is long b/c of the potential for first/middle names, initials, etc. If I could get the formula to read the text from right to left, I could just use the text in the field up to the...
I have a 50-character text field that is in all upper case, and I want to change it to proper case- the first letter of each word in upper case, and the rest in lower case. I've created a very basic formula to take care of one-word entries:
left({field},1) + lowercase(mid({field},2,50))
But I...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.