get the last character from a string after a character in SharePoint Calculated Column
ROY-AMD-BOL-727
I am trying to extract the last letters after the character "-".
Solution
You could use this formula.
=RIGHT([test],LEN([test])-FIND("-",[test],FIND("-",[test],FIND("-",[test])+1)+1))
Result:
- Unable to authenticate SharePoint REST or CSOM calls from .NET Core
- How to setup a connection to Sharepoint with enterprise app and client secret
- Power Automate Send an HTTP request to SharePoint returns BadGateway error when creating a Lookup field
- Word file from SharePoint corrupted when sent via Outlook
- Copy “latest files” from source to Sharepoint using KNIME
- Why does SharePoint JavaScript define a function named “ULSTYE” and a label for an empty statement with the same name?
- File upload to SharePoint is not working and is not throwing any errors
- Loading ETag property when retrieve items as a stream in SharePoint
- How to subscribe to updates to the root drive of a SharePoint Site using Microsoft Graph
- Powerapps Form does not map correctly fields
- Attempting to set DisableCustomAppAuthentication to false for Azure not working from Powershell
- troubleshoot display SharePoint columns from Infopath calculated fields
- can't display error messages with customErrors=Off in SharePoint 2010
- Accessing Excel file from Sharepoint with R
- SharePoint REST API returns invalidRequest apiNotFound when registering Container Type
- Getting two acces tokens using single login prompt for sharpoint api and graph api
- How to Download file from Sharepoint to local drive using VBA in an Excel Macro
- Azure Event Grid Graph API SharePoint Event info useful?
- obtain item-id for microsoft graph api
- Calling azure function from spfx webpart result 401 Unauthorized
- How to use .HTMLBody to hyperlink a cell value?
- How do I interpret error codes from FrontPage Extensions?
- APIs and Data storage - Microsoft / Server
- How to write the first 4 letters of the company name of the person who created a new item in a Sharepoint list using PowerAutomate
- ASP.net page without a code behind
- Using Power Automate to save emails in SharePoint location based on List Entries
- sharepoint powershell - Exception calling "ExecuteQuery" with "0" argument(s): "The underlying connection was closed:"
- Upload a file in C# Asp.Net Core to Sharepoint/OneDrive using Microsoft Graph without user interaction
- In Power Automate Parse JSON step I get the errors "missing required properties"
- SharePoint2013 - Javascript - Pagination in client side- Using listitemcollectionposition