Fred_Smith1 - profile

Fred_Smith1 · Mar 07, 2022

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...

Fred_Smith1 · Mar 08, 2022

That suggestion helped a lot. I didn’t use REGEX_REPLACE, but I did use REPLACE. For example: Input: {Asset Last Logged In User} = WSSUMITS\smithfred Formula: REPLACE({Asset Last Logged In User},1,9,"") Output: {Domain removal} = smithfred Then I can...

Fred_Smith1 · Mar 08, 2022

I double checked and the Asset Last Logged in User is a string. All users are recorded as domain\username. When I test the regex in regex101 or RegExr, it gives me exactly the output I’m looking for. In fact, I used the example that is given in Airta...

User Statistics

User Activity

REGEX_EXTRACT Help

Re: REGEX_EXTRACT Help

Re: REGEX_EXTRACT Help