Newbies JacJS Posted December 24, 2010 Newbies Posted December 24, 2010 I was hoping someone might be able to help me create the following calculation in Filemaker Pro Advanced 8.5: I have 2 fields: "First Name" and "Surname". I was hoping to create a separate field that automatically entered the initials of the name, eg. John Smith = JS What formula do I need? Please help.
bcooney Posted December 24, 2010 Posted December 24, 2010 Left ( First Name ; 1 ) & Left ( Surname; 1) However, you'll probably have problems with people who are named: Cher, von Blout, de Ville. Derived initials can be tricky.
Recommended Posts
This topic is 5139 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now