Introduction

SharePoint Lists support a number of functions similar to Excel.

Below shows how to use the MID function to create a new List column containing server hostnames derived from an existing column containing fully qualified domain names (FQDN).

————

Create a new column ‘hostname‘ in the SharePoint list using Calculated column type and enter formula

=MID([FQDN],1,FIND(".",[FQDN],1)-1)

using data type Single line of text

Example

FQDN hostname < ‘hostname’ function >
1 dc.tecivo.local dc =MID([FQDN],1,FIND(“.”,[FQDN],1)-1)
2 exchange.tecivo.local exchange =MID([FQDN],1,FIND(“.”,[FQDN],1)-1)
3 sharepoint.tecivo.local sharepoint =MID([FQDN],1,FIND(“.”,[FQDN],1)-1)