Jump to content

Formatting Email Address


Recommended Posts

Do all email names follow the "FirstInitial,LastName" format?

Is the domain (abc.com) the same for all records?


If so, then:

//replace "YOUR_FIELD" with field from your data
var YourField = Field("YOUR_FIELD");
var First2Letters = Left(YourField, 2);
var CorrectUser = YourField.replace(First2Letters, First2Letters.toUpperCase());
var NewEmail = CorrectUser.split("@",1) + "@ABC.com";
return NewEmail;

Link to comment
Share on other sites


This topic is now archived and is closed to further replies.

  • Create New...