I am trying to use REGEX_EXTRACT to convert a username into an Email address. For example: WSSUMITS\smithfred => smithfred, then I can add the @domain.com to the result.
The regex formula I came up with, through trial and error, is:
REGEX_EXTRACT({As...