I'm taking an existing store's information and uploading to a new version (Magento). The old site stored the customer name as the whole name
John Smith, whereas Magento requires a first and last name field.
I understand that I could separate the name by space, however, some last names are 2-words,
Van Smith, and some names are also 2-words,
Mary Beth. So the option of splitting the name by the space would not suffice for this solution.
Does anyone have any ideas to solve this? Thanks in advance.