AnsweredAssumed Answered

How do I "split" first name/last name into two separate files?

Question asked by MichaelKissinger on Apr 19, 2011
Latest reply on Oct 22, 2016 by oldgustav

Title

How do I "split" first name/last name into two separate files?

Post

Can someone please tell me how to separate or split the data in FIRST NAME into First Name and Last Name fields?

For example, I just imported a HUGE database, and the names are all like this: JIM SMITH, and "JIM SMITH" is all in ONE field.  However, I want JIM as a First Name, and SMITH as a Last Name field.

So, how do I split this?

Outcomes