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
sudha76sudha76 

Formula to extract certain characters from the Task Description Field using TRIM

Here is my formula to extract first few lines from the TASK Description (Standard) Field.

 

TRIM(RIGHT( Description , 200))

 

The above works but not exactly.

 

I get the content which starts from the middle of the paragraph. How can I write this?

lakslaks

Hi Sudha,

 

RIGHT( Description , 200) would return  the specified number of characters from the end of the string.

 

If you need the first 200 characters you would have to use LEFT(text, num_chars).

 

Regards,

Lakshmi.