Not to make your life more difficult but a comma in a company name is pretty common so making the assumption that the presence of a comma is a delimiter between last name and first name is going to bite you. Ideally you would have a separate column to store the parts of a name as well as the company. It sounds like you're just storing the name in a single column. If you really want to nudge your user's, change the UI to make them enter parts separately, even if you're not storing them that way.
Frank Burcaw wrote: > What I'm trying to accomplish is a way to nudge the user in to > entering name data consistently. > > Our preferred methods for people are listed below: > > BURCAW, FRANK > BURCAW, FRANK W > BURCAW, FRANK & STEPHANIE > > This will allow for better sorting in grid views. When it's time to > print, then I'll rearrange them to a first name last name layout. No > commas would indicate that it is a company name. > > So I was trying to build a regular expression that would match the > last name, first name pattern as long as a list of words also did not > exist. > > I'l still struggling with this and would appreciate any assistance. > > Best regards, > > Fran -- Richard Kaye Vice President Artfact/RFC Systems Voice: 617.219.1038 Fax: 617.219.1001 For the fastest response time, please send your support queries to: Technical Support - [EMAIL PROTECTED] Australian Support - [EMAIL PROTECTED] Internet Support - [EMAIL PROTECTED] All Other Requests - [EMAIL PROTECTED] --------------------------------------------------------- This message has been checked for viruses before sending. --------------------------------------------------------- _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
