Splitting Name Field into First and Last Name Fields

  • Thread starter Thread starter Eve
  • Start date Start date
E

Eve

The database has over 77000 records.
The name field is such: lastname,firstname.
Can it be split into two separate fields, for example
using the comma as separator?
 
Eve said:
The database has over 77000 records.
The name field is such: lastname,firstname.
Can it be split into two separate fields, for example
using the comma as separator?

FirstName = Mid([YourField], Instr(1, [YourField], ",")+2)
LastName = Left([YourField], Instr(1, [YourField], ",")-1)

Unless there really is no space after the comma as in your post. Then the first one
is +1 rather than +2.
 
Eve said:
The database has over 77000 records.
The name field is such: lastname,firstname.
Can it be split into two separate fields, for example
using the comma as separator?

Hi Eve,

I use Splitter for Microsoft Access to split names in Access databases.
It's designed to make this task as painless as possible.

http://www.infoplan.com.au/splitter

- Julie
 
Back
Top