Hello

I need a formula to extract the 2nd entire line of a paragraph("PAR"). And I need a formula to get the third line only. "PAR"

I appreciate your help very much.

STan

"par" is the paragraph field name.

FileMaker Version: 7

Platform: Mac OS X Panther

Stan,

Since fields are text wrapped automatically, and there is no built in function to extract text by line, you would need to set up your field with a fixed width font like Monoco or Courier, and count the number of characters that fit on one line. you can then use this in a calculation to extract the middle text:

Middle ( text ; start ; numberOfCharacters )

I believe that Mike is correct. However, if you wish to extract the second entire sentence instead of line, it is quite possible. You can use your period/space to count the number of occurences within each PAR (field) and parse them out however needed. So, do you mean line, Stan, or will sentence work?

Also, are these lines ending in

I mean line. Sorry Easter stuff going on.

Thanks for the answers

Stan