You need to sign in to do that
Don't have an account?
liron169
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?
I dont think there is any other way. You need to write a Trigger
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))
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.