Activity Forums Salesforce® Discussions What are Salesforce formula fields?

  • What are Salesforce formula fields?

    Posted by D on May 3, 2019 at 9:46 am

    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)))

    lavish replied 5 years, 6 months ago 2 Members · 1 Reply
  • 1 Reply
  • lavish

    Member
    May 17, 2019 at 9:48 am

    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

Popular Salesforce Videos