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
Vrushali Mali 4Vrushali Mali 4 

how to use LEFT RIGHT and MID function

Hello people,

i Have Account Name for eg MEDITERRANEAN SHIPPING LTD CO and i want to display MEDSHI  that is first 3 letters of the first word and 3 letters of the second word. And it should apply for all account.
Akshay_DhimanAkshay_Dhiman
Hi vrushali,

Try this way out for building your Text ,

MID(Name , 0, 3) &  MID(Name ,  FIND( ' ', Name)+1  , 3)

If you found this answer helpful then please mark it as best answer so it can help others.

Thanks 
Akshay
Tania B GarciaTania B Garcia
Hi Akshay_Dhiman

I have a case where I have the Amount field which comes in a description field, then I'm using the LEFT and RIGHT MID, since the amount may vary in numbers, could you please help me to know how to use it when working in varying lengths
an example is
Amount: $ 500,000.00
Amount: $ 78,546,000.00
Amount: $ 7,963,877,100,300,000.00

Thanks and Regards
Tania García