Jump to content
Salesforce and other SMB Solutions are coming soon. ×

How many lines of text in a field


gbenic

Recommended Posts

You might want to start with this formula ...

 

Lines = PatternCount( text, "¶" ) +1

 

This assumes that your definition of lines means text seperated by a return, including blank lines. If there are extra returns within or after the text, they will also be included in the count.

 

You might want to modify the formula so it does not count instances where two(or more) returns occur back to back.

Link to comment
Share on other sites



×
×
  • Create New...

Important Information

Terms of Use