Skip to main content

How to remove special characters from the SharePoint list column using calculated column - SharePoint online



Remove special characters  from the SharePoint list column using calculated column



=REPLACE([FirstNameLastName],SEARCH("&",[FirstNameLastName]),0,"")


or
=IF(ISERR(SEARCH("&",Title,1)),Title,REPLACE(Title,SEARCH("&",Title,1),2,""))

 Source
https://social.technet.microsoft.com/Forums/sharepoint/en-US/42391d83-a6eb-480f-b84a-3d43ef4f5e40/calculated-column-to-remove-amp-and-space-quotamp-quot?forum=sharepointgeneralprevious

https://social.technet.microsoft.com/Forums/office/en-US/74d8022b-03f4-4ccf-9bfc-a3075a2f9202/multiple-replace-on-calculated-column?forum=sharepointgeneralprevious

Comments

Post a Comment

Popular posts from this blog

How to display SharePoint list item status values into images/icons using simple JavaScript src="http://code.jquery.com/jquery-latest.min.js" $(document).ready(   function() {     $('td.ms-vb2:contains("Completed"), ' +       'td.ms-vb2:contains("Pending")').each(         function() {           $(this).hide();           $(this).html(ReplaceColorTextWithImage($(this).html()));           $(this).show("slow");         }     );   } ); function ReplaceColorTextWithImage(strColorText) {   var strColorImage = "";   switch(strColorText) {     case "Completed":       strColorImage = "green";       break;     case "Not Started":       strColorImage = "Red";       break;   }  return " " }  ...
Post a Comment
Read more