Jump to content

Formatting Email Address


petra

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

Archived

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

×
×
  • Create New...