Expression - domain\user.name to user.name@domain.com

[jpjust]

All,

I have a field like below.

UserID

domain\user.name

domain\user.name2

I want a new field like below.

emailID

user.name@domain.com

user.name2@domain.com

I am looking forward for an solution on both UI expression and script expression.

Here is the code on the script.

LOWER(userDirectory & '\' & userId) AS UserId,

Thanks

[anat · Accepted solution]

load subfield(UserID,'\',2)&'@'& subfield(UserID,'\',1)&'.com' as emailID,*;

load * inline [

UserID

domain\user.name

domain\user.name2
];
exit script;

[jpjust]

Thank you so much, it works.