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) |
Leave a Reply