Just sharing a simple example of using the RIGHT and LEFT functions to extract the required content from a particular column. E.g. we want to extract the name (FirstName, LastName, Mobile) from the below column in the Excel Here we can apply RIGHT(text, [num_chars]) function to first remove the characters <xs:element name=” i.e. 18 characters … Continue reading “Using RIGHT and LEFT string…
Continue Reading Nishant Rana’s Article on their blog
Using RIGHT and LEFT string functions in Excel
Just sharing a simple example of using the RIGHT and LEFT functions to extract the required content from a particular column. E.g. we want to extract the name (FirstName, LastName, Mobile) from the below column in the Excel Here we can apply RIGHT(text, [num_chars]) function to first remove the characters
Blog Syndicated with Nishant Rana’s Permission
More About This Author
Array
- Dyn365CE6 May 2024Fixed – The latitude or longitude for the User record associated with this resource is invalid – Dynamics 365 Field Service /Dataverse
- Dyn365CE30 April 2024Use Geolocation Settings for Location Tracking and Auditing – Dynamics 365 Field Service
- Dyn365CE29 April 2024Fix the trigger – Microsoft.OData.ODataException: A binary operator with incompatible types was detected. Found operand types ‘Edm.Guid’ and ‘Edm.String’ for operator kind ‘Equal’ (Power Automate / Dataverse)
- Dyn365CE23 April 2024Portal does not load and displays “Server Error” or shows “Getting set up.. This might take a while” message -Portal Startup Issue (PowerApps Portal)