AnsweredAssumed Answered

Remove 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 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!