Jump to content

how do extract the second line only of paragraph


This topic is 6495 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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

Link to comment
Share on other sites

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 )

Link to comment
Share on other sites

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

Link to comment
Share on other sites

This topic is 6495 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.