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.