If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Splitting Text Field
I link to a network shared .dbf file. One of the fields stores individuals
names. When the .dbf is refreshed, I append that field data to a table in Access. What I would like to do is separate field text from original linked table into the Access table to have last name, first name, middle, etc. separated so I can format system-generated correspondence more professionally. Example data in linked table field (call in NAME): BROWN JOE JOHN GEORGE III (sometimes I have names with 2 middle names) Desired results: LNAME (field) FNAME (field) MNAME (field) MNAME2 (FIELD) SUFFIX (field) if it's too complicated I can even ignore middle name(s) and suffix and only go with first and last names. |
#2
|
|||
|
|||
The family of string functions can help you.
See Left, Right, Mid, Instr, and Len in the Help file for more info. intPos = instr(Namefield, " ") strLName = Left$(Namefield, intPos-1) InfoPlan has a product called Nameparser that's pretty handy as well. http://www.infoplan.com.au/nameparser/ Tell 'em I sent ya. -- Steve Clark, Access MVP FMS, Inc. www.fmsinc.com/consulting "sfcwarren" wrote in message ... I link to a network shared .dbf file. One of the fields stores individuals names. When the .dbf is refreshed, I append that field data to a table in Access. What I would like to do is separate field text from original linked table into the Access table to have last name, first name, middle, etc. separated so I can format system-generated correspondence more professionally. Example data in linked table field (call in NAME): BROWN JOE JOHN GEORGE III (sometimes I have names with 2 middle names) Desired results: LNAME (field) FNAME (field) MNAME (field) MNAME2 (FIELD) SUFFIX (field) if it's too complicated I can even ignore middle name(s) and suffix and only go with first and last names. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Linking text boxes | Volunteer Mom | Publisher | 7 | November 12th, 2008 01:29 AM |
Design help, please | SillySally | Using Forms | 27 | March 6th, 2005 04:11 AM |
Numbers to appear at the cursor... | ~D~ | New Users | 11 | February 1st, 2005 04:49 AM |
Change Text field (with numbers) DataType to Number | Michael Miller | Database Design | 1 | November 4th, 2004 08:04 PM |
NUMBERING the pages | Bob | New Users | 7 | June 14th, 2004 12:20 AM |