Hello, I need to create a field that has the Email Domain for a person record, so if their email address is email@example.com, then the email domain would be “abc.com”.
I’ve tried doing it with Substring() via a calculated field and also a rule. I tried in a rule to do the transform task to get the position first and then added another transform task to use the position in a substring function, but it wouldn’t take a fieldname. It seems like it requires a hard coded number, so instead of being able to do something like substring(email address, @position, length), it seems that it wants something like substring(email address, 4, 10).
Is there any way for me to do this in Gainsight?
Best answer by jean.naironView original