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:
- why 'PrimitiveValue' or 'StartObject' node was expected error
- Upload file to SharePoint using REST API
- Best way to resolve file path too long exception
- Optimal/preferred way to call 'SP.ClientContext.executeQueryAsync' in SharePoint
- Trouble/How to get the Document Library of my SharePoint Site using GRAPH API
- Sign in as different user in SharePoint 2013
- obtain item-id for microsoft graph api
- Power apps - Multiple Sharepoint lists combine as collection and display in one gallery
- SharePoint REST API getFolderByServerRelativeUrl Returns Nothing
- System.IdentityModel.Tokens.Jwt not found
- Microsoft Graph API and SharePoint files permissions
- How to programmatically download a file from a synced SharePoint directory in Windows?
- Using R to connect to a sharepoint list
- Sharepoint permissions to folders using powershell pnp
- Add additional site page library to SharePoint
- Attaching files from SharePoint uses %20 for spaces in filenames
- Accessing SharePoint Files via API Results in 'AudienceUriValidationFailedException'
- Granting permissions to upload a file to sharepoint using PnP Powershell - 401 Unauthorized
- I can't get the folders from my sharepoint site, how can i resolve this?
- How can I detect if a document is successfully rendered in Office Online Server using PowerShell?
- How to upload files from Jenkins to SharePoint: REST API or OneDrive sync?
- 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