In Progress

Filemaker--Split Full Name field into First and Last Name

Hi, I have a Filemaker 11 database of 4,500 records in which the contact person’s full name is concatenated into one field, for example, “John Brown”. I want to parse the Full Name field, so that John and Brown” to go into separate "First Name" and "Last Name" fields.

I want to send you the Filemaker database, you write the formula, run it, and send me back the database with the “Full Name” split into two new fields of First Name, and Last name.

There are a few incidents of “John A. Brown” Otherwise, the data is very consistent. (I haven’t seen “Dr. John A. Brown, Jr.” if he exists, we can correct him separately by hand. I don’t need the middle initial.

I can even send you to a link which specifically shows you the formulas and FM functions required.

I am thinking that this shouldn't take more than an hour--at the most.

Skills: FileMaker

See more: split name last filemaker, separate last name filemaker, split name last name filemaker, separate field filemaker, filemaker split full name, parse field filemaker, filemaker split name field, filemaker split last name fields, split name field filemaker, middle name filemaker, it field, dr first, brown and brown, filemaker name split, filemaker separate, split, name, name + it +, last, last seen, jr, first person, filemaker, filemaker data, name last name

About the Employer:
( 0 reviews ) Sausalito, United States

Project ID: #1135908

Awarded to:

timlit

hi. a 5 minute job. can deliver tomorrow, if ok.

$30 USD in 1 day
(2 Reviews)
1.6