# of lines

[mhudd]

Is there a calc that counts the number of lines in a text field?

[SteveB]

If you define # of lines by the # of CRs, then yes: PatternCount(string,"P") where "P" is the CR character.

[danjacoby]

With wrapped text, it's a lot harder. You can get an approximation with a calc field:

code:

---

Int(Length(TextField) / ##)

Where "##" is the number of characters in an average line. Monospaced fonts (like Courier) make it easier to determine this.

Frankly, this is just an approximation, though. The thing is, FMP isn't a word processor, so it doesn't really have those word processing "extras", like word count and line numbers.

[BobWeaver]

Actually you can count number of lines of wrapped text exactly with a script, which counts pages on a carefully constructed layout. I have an example file on my stupid filemaker tricks webpage:

http://members.shaw.ca/indexel/download.htm