function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
liron169liron169 

Get the first line form long text field

Hello,

 

Is there any way to get the first line from long text field without writing a trigger?

 

I read somewhere that formula function cannot detect break line, so maybe with workflow rule or any other solution?

Rahul_sgRahul_sg

I dont think there is any other way. You need to write a Trigger 

SoleesSolees

What if you try finding the character position of the 'new line' or 'return' and then you use the left operaction.

 

Like this:

LEFT(Email, FIND("@", Email))

liron169liron169

Solees,

That the problem - the FIND function cannot detect new line character.

I try:

FIND('\r', field)

FIND('\r\n', field)

FIND('\n', field)

 

No one works.