Activity Forums Salesforce® Discussions What are Salesforce formula fields?

  • D

    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

    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.

Viewing 1 - 2 of 2 posts

Log In to reply.

Popular Salesforce Blogs

Popular Salesforce Videos