Skip to main content
K
Karolus
Known Participant
September 16, 2011
Question

Requesting help in splitting name field

  • September 16, 2011
  • 1 reply
  • 790 views

I'm moving from my CRM Goldmine to another CRM.  Goldmine keeps the name in the "Name" field with both first and last name.  The new CRM keeps is name in two fields: "Firstname" & "LastName"

I have my data in an Access Database.  How can I split the name to get the the first name separated from the lastname.

For example:  How do I split "John Smith" in one column into two columns "John" & "Smith"

Thank you for all your help.

Karolus

    This topic has been closed for replies.

    1 reply

    D
    Dan_Bracuk
    Inspiring
    September 16, 2011

    With great difficulty.

    John Smith is easy.  Treat it as a space delimited list.  The problem comes with names like John Paul St Pierre.

    If this was my problem, I'd probably do the simple ones automatically and the complicated ones manually, as long as there weren't too many of them.

    ilssac
    ilssac
    Inspiring
    September 16, 2011

    Dan Bracuk wrote:

    The problem comes with names like John Paul St Pierre.

    Or my favorite name example "Mary Sue Ellen van der Longname"

    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices