BarbAvila Posted January 28, 2008 Share Posted January 28, 2008 I have a database that has a name field and then calculation fields to pull out First, Last, and Middle names. I cannot figure out a way to make it work with hyphenated last names. Before FMP7, I could just type a command + - to get a non-breaking hyphen. But since FMP7, a hyphen starts a new word. Is there a calculation than will work? TIA BarbAvila Link to comment Share on other sites More sharing options...
LingoJango Posted January 28, 2008 Share Posted January 28, 2008 It's much, much better to have separate fields for first, last and middle, and then do a calc to put them together. But a calc that ought to work would be one that replaced "-" with "^" or some other symbol that is not a word break, then extracted the words, then substituted the hyphen back in again. Link to comment Share on other sites More sharing options...
BarbAvila Posted January 28, 2008 Author Share Posted January 28, 2008 I realize that. I did this database for some "not so savvy" users and they kept forgetting to tab to the next box! But I'll try your suggestion and if I can't get it to work, I may go ahead and change it back and hope for the best. Thanks! Barb Link to comment Share on other sites More sharing options...
HBMarlowe Posted January 28, 2008 Share Posted January 28, 2008 I realize that. I did this database for some "not so savvy" users and they kept forgetting to tab to the next box! Even the "not so savvy" will get it eventually if you require data in the first and last name fields. Link to comment Share on other sites More sharing options...
BarbAvila Posted January 28, 2008 Author Share Posted January 28, 2008 Good point. I originally did this database about 7 years ago. It needs a complete overhaul by this time . . . Link to comment Share on other sites More sharing options...
By Soliant Consulting,
By Soliant Consulting,
By Soliant Consulting,
Recommended Posts