You need to sign in to do that
Don't have an account?
Jack Nedelman
How search for carriage return in formula
I am trying to find the carriage return in case description field. I used these formula listed below. Everytime it returns zero.
Any ideas how I can find the line break?
Both of these items below return zero. There is definetely a line break in my description field
FIND('\r', Description,1 )
FIND('\n',Description,1 )
Any ideas how I can find the line break?
Both of these items below return zero. There is definetely a line break in my description field
FIND('\r', Description,1 )
FIND('\n',Description,1 )
Can you try with either of the following.
FIND('\r\n', Description,1 )
FIND('\\n',Description,1 )
Regards,
Sridhar Bonagiri