Fetching First name and last Name from email ID

[Savita P]

How we can fetch first name, last name from email id and store it to fields?

Thanks.

[AbhishekGardade]

Can you please elaborate more?

What is the email format you are receiving?

Please mark as Correct Answer/Helpful, if applicable.
Thanks!
Abhishek Gardade

[AbhishekGardade · Accepted solution]

Sample script:

var empMail = 'abhishek.gardade@company.co.in';

var fullName = empMail.split('@')[0].split('.');

var firstName = fullName[0];

var lastName = fullName[ fullName.length-1 ] ;

gs.log("firstName: "+firstName);

gs.log("lastName "+lastName );

Please mark as Correct Answer/Helpful, if applicable.
Thanks!
Abhishek Gardade

[Savita P]

The email format is: firstname.lastname@xxxx.com