AnsweredAssumed Answered

Remove @company.com characters from string field

Question asked by KatherineShier on Oct 12, 2017
Latest reply on May 15, 2018 by JTedrick-esristaff

My form is capturing the username by default which is the full email address. I would like to remove the @company.com so that I'm just left with firstname.lastname in a field called 'User'.

 

I have looked at using an input mask, regex and a calc along the lines of substr(${username},-21) but haven't quite cracked it. I would imagine this would be quite a common requirement?

 

The email address would always be in the same format. 

Any suggestions welcome! 

 

 

Outcomes