topic Expression - domain\user.name to user.name@domain.com in App Development

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

jpjust — Wed, 26 Jan 2022 14:09:19 GMT

All,

I have a field like below.

UserID

domain\user.name

domain\user.name2

I want a new field like below.

emailID

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 — Wed, 26 Jan 2022 14:19:07 GMT

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

load * inline [

UserID

domain\user.name

domain\user.name2
];
exit script;

jpjust — Wed, 26 Jan 2022 15:51:18 GMT

Thank you so much, it works.