Shopping Cart
Contact
FileMaker is a registered trademark of FileMaker, Inc. in the U.S. and other countries.
|
||||||||||||||||||||||||||||||||||||||||
ExtractLine ( TextField ; LineNumber ) Rate this function:   Discuss this Custom Function Michael Haymore, N/A Return a specific line out of a text field.
Description:This is an easy way to pull a specific line of text out of a field that has it's data seperated by carriage returns. If you try to get a get a line of text that is not available, it will return a "?". Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems. This is my Custom Function and I want to edit it Discuss:Make a comment about this Custom Function (please try to keep it brief & to the point). Anyone can post: |
|
|||||||||||||||||||||||||||||||||||||||
The above custom function works great, but does not pull the last value of the field. There must be a "¶" after the last value for the function to fully work. The following works properly.
Let ([
TextSource = TextField & "¶";
TextLine = Middle (TextSource; Position ( TextSource; "¶"; 1; LineNumber - 1) + 1;
Position ( TextSource; "¶"; 1; LineNumber) - Position ( TextSource; "¶"; 1; LineNumber - 1) - 1
)];
If ( IsEmpty (TextLine); "?"; TextLine)
)
Chris Lord-Paquin, Manchester, NH
May 04, 2009 7:40am