Mapping to parse full name and import as first name and last name

(0) Share

Report

Posted on by Indhu

Hi Team,

I like to import the csv file with fullname, region and other details. but the required fields are first name and last name. how should i parse them and set as first name and last name

Nya -can you help me in this?

All responses (2)

Answers (1)

Indhu 55 on at

Like (0)

Report

RE: Mapping to parse full name and import as first name and last name

Helpful thanks :)
Verified answer

Community Member Microsoft Employee on at

Like (0)

Report

RE: Mapping to parse full name and import as first name and last name

Hi,

I think the easiest way to do this is that open your csv file by Excel and add two columns(First name and Last name). Then use the feature Text to columns in the toolbar Data to split your Full Name column.

Steps:

1. Select context you want to split and click the Text to columns button.



2. Select your Delimiters and click Next.



3. Select the Destination in your worksheet and click Finish.



4. Then you can import this csv into Contact entity.