String Function

[#1]

Is there a string function to convert my string of type servername.na.corp.companyname to servername.

I have to delete the .na.corp.companyname part.

[#2]

Please try this:

if(isnum(Subfield(YOURFIELD, '.',1)), trim(replace(YOURFIELD,'.sa.corp','')), Subfield(YOURFIELD, '.',1))

This should work