AnsweredAssumed Answered

Remove characters from string field

Question asked by KatherineShier on Oct 12, 2017
Latest reply on Oct 17, 2018 by henrycl3

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!