Extract Word(s) between Characters (in the Description field) using formula #inSalesforce
Suppose you want to extract from the description field with details and in between there is a fixed URL like .... <https://test.com/s/Get_This> ....
Lets extract the word(s) between "/s/" and ">" that is Get_This
Use formula like:
MID(Description, FIND("/s/", Description)+3,FIND(">", MID(Description, FIND("/s/", Description)+3, 255))-1)
Visual: https://www.youtube.com/watch?v=H0CBZU-sAvc
Comments
Post a Comment