Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Please try this:
if(isnum(Subfield(YOURFIELD, '.',1)), trim(replace(YOURFIELD,'.sa.corp','')), Subfield(YOURFIELD, '.',1))
This should work