function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
bhanu_prakashbhanu_prakash 

Getting extra string

I have created a formula field to pull value after /
MID(
    BillingStreet ,
    FIND("/", BillingStreet )+1,
    FIND(" ", RIGHT(BillingStreet , LEN(BillingStreet) - FIND(" ", BillingStreet )))-1)

Input: 26/12 IMA way  o/p: by using above formula Iam Getting 12 I
But I need only 12, Some thing number(12) length will maxium 4 characters
 
LBKLBK
Hi bhanu,
Try this formula. 
MID(
    BillingStreet ,
    FIND("/", BillingStreet)+1,
    FIND(" ", BillingStreet) - FIND("/", BillingStreet))
Let me know how it goes.
 
bhanu_prakashbhanu_prakash
yeah, i tired that too Showing same result
LBKLBK
Are you sure? Because, it works perfectly for me. I have tried from 0 to 10 characters after / symbol. It worked.