i'm having trouble Formatting Email Address

[petra]

I need a code to convert email address by default to below:

from jdoe@abc.com to JDoe@ABC.com.

I have the code to force the domain, but cant figure out how to return the name in the format above.

 

Thanks

[esmith]

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;

[petra]

thank you for the help works like a charm