Tuesday, September 22, 2015

SharePoint 2013: Find and Replace string in Calculated columns
// Replace '.' with '-'
=REPLACE([IP Adresse],FIND(".",[IP Adresse]),1,"-")

// Replace all the '.' to '-'. This means '192.168.191.51' becomes '192-168-191-51'

=REPLACE(REPLACE(REPLACE([IP Adresse],FIND(".",[IP Adresse]),1,"-"),FIND(".",REPLACE([IP Adresse],FIND(".",[IP Adresse]),1,"-")),1,"-"),FIND(".",REPLACE(REPLACE([IP Adresse],FIND(".",[IP Adresse]),1,"-"),FIND(".",REPLACE([IP Adresse],FIND(".",[IP Adresse]),1,"-")),1,"-")),1,"-")

No comments:

Post a Comment