-
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
Whopping 50 Percent Year-over-year Gain in Global Online Sales – Salesforce Data
As per data revealed by CRM specialist Salesforce, consumers spent $1.1 trillion online worldwide and $236 billion in the U.S. as compared to 723 billion…
Smart Dynamic Forms for Salesforce
Do it yourself - Dynamic forms, conditional logic and realtime field population for salesforce without writing a single line of code. When working with online…
Salesforce Interview Question – Part 2
1. What is an interface in apex? Ans. An interface is like an Apex class in which none of the methods has been implemented. It only…
Popular Salesforce Videos
Introduction to Flow in Salesforce
This informative video on flows in Salesforce contains the following topics:- 00:00 - Introduction 02:14 - Agenda 02:49 - Flow is Automation 03:35 - The…
Explain Data Management in Salesforce?
Data loader is a tool to process bulk records and we can process a maximum of five million records with the data loader. Watch this…
Getting Turn by Turn Directions Between Scheduled Events | Salesforce Maps Mobile
Watch this video to learn how to get turn-by-turn directions between scheduled events in Salesforce Maps Mobile. 00:00 - Introduction 00:19 - Access your Schedule…
