How can I calculate the first part of a subdomain name
I want to have a field that returns the first part of a subdomain name. For example if the subdomain is
How can I have a field that just gives me name
I'm assuming it's a calculation but I can't figure out how do calculate it. Your help is much appreciated.