Mitsules, Mark S. (Newport News)
Mark.Mitsules at ngc.com
Mon Apr 12 15:24:00 CDT 2004
Microsoft Knowledge Base Article - 168799 HOWTO: Parse a Person's Name into Multiple Variables http://support.microsoft.com/?kbid=168799 Pay particular attention to the assumptions...but this should give you a good start. Mark -----Original Message----- From: Coutts, Welford L. [mailto:COUTTSW at rjrt.com] Sent: Monday, April 12, 2004 3:48 PM To: Access Developers discussion and problem solving Subject: [AccessD] Separating First and Last Names I have received a large file containing a large number of Full Names. I need to separate the First Name and Middle Initial, if any, into one field and the Last Name into a separate field. What is the most efficient way to do this? Thanks! Welford Coutts ----------------------------------------- CONFIDENTIALITY NOTE: This e-mail message, including any attachment(s), contains information that may be confidential, protected by the attorney-client or other legal privileges, and/or proprietary non-public information. If you are not an intended recipient of this message or an authorized assistant to an intended recipient, please notify the sender by replying to this message and then delete it from your system. Use, dissemination, distribution, or reproduction of this message and/or any of its attachments (if any) by unintended recipients is not authorized and may be unlawful. -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com