Is there a way to remove all the characters after a specific character in a field? Or only take the value before a character? For example the input is “[email protected]” what I’d like included in the calculation is only “johnsmith” and disregard everything after the “@” character.

Thank you very much!