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 Search or get the documents in subfolders of Document library in SharePoint Option 1  Using CAML Query below CAML query used to filter                     Sites /SiteCollectionName/SubsiteName/DocumentLibraryName/Folder Name/SubFolderName/SubSubFolderName/SubSubSubFolderName       Source https://sharepoint.stackexchange.com/questions/60495/caml-query-for-sub-folder-documents-javascript https://sharepoint.stackexchange.com/questions/59216/get-all-files-from-sub-folder-of-a-certain-content-type https://sharepoint.stackexchange.com/questions/215230/get-all-items-in-list-by-field-name-caml-query Option 2 Create a View which can point to SubFolder by changing the filter for the view using SharePoint Designer Source:  https://www.tombenjamin.ca/blog/designer/view/using-caml-query-show-files-folder/ There is a thread on  social.technet  where someone asks how to “Create a we...
Post a Comment
Read more
Get Email User Name, email from SharePoint person field in list  you can get user name and email from person field is the group or person coloumn Create PersonGroupCol - person or group field If you are not going to use those email address values later (you don't need to save emails in column) and you just want to show the email in SharePoint list view then you can also achieve it using JSON column formatting. Create one single line of text column (Email, Name) Hide it from list forms (make it  Hidden  from content type settings). Then use below JSON code to format the column: { "$schema" : "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json" , "elmType" : "div" , "txtContent" : "[$ PersonGroupCol . email ]" } For User Name { "$schema" : "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json" , "elmType" : "div...
Post a Comment
Read more