-
What are Salesforce formula fields?
i have text string divides with slashes ,
string contains in one text field by using formula field i need to show from last two slashes text ..
EX :Default Category/Home Video,Default Category/Home Video/Blu-ray/DVD,Default Category/Home Video/Limited Editions
Here :o/p Home video/Limited Editions
Here text varies from record to record ...
i written like :LEFT(RIGHT(Category__c,LEN(Category__c) - FIND("/", Category__c)),
FIND("/",RIGHT(Category__c,LEN(Category__c) - FIND("/", Category__c)-1))) -
1 Reply
-
I think we can't achieve it with requirement field formula. It's an interesting question. It would be great to learn about it more.
Log In to reply.
Popular Salesforce Blogs
Personalized Marketing Automation: Three Strategies And Examples
Marketing teams do their best to create an engaging, powerful, and personalized experience for customers from their first visit to the website to make a…
Insert Record using JavaScript Remoting with Visualforce Page
Hey there! We must have heard about javascript remoting. So today we are going to learn about how to use the Javascript remoting to build…
How Does Salesforce Revenue Cloud Benefit Sales and E-Commerce Businesses?
As Sales and E-Commerce business channels are affected by the ongoing pandemic, the generated revenue and customer demands are also deteriorating at an equal pace.…
Popular Salesforce Videos
Practice Test and Questions for Salesforce Platform App Builder Certification Exam
In this video, Shrey provides a practice test for the candidates who are preparing for the Salesforce Platform App Builder Exam. This test boosts your…
Data Import: Prepare your Data for Import | Salesforce
This short video walks you through how to clean up your import files in preparation for getting your data into Salesforce. We'll walk you through…
Dynamic Action in Salesforce | Salesforce Tutorial
In this video, we are going to talk all about dynamic actions in Salesforce. 00:00 Introduction 00:57 Work with Dynamic Action 05:05 Dynamic Actions in…
