Brian Dunning's FileMaker Custom Functions

getLine ( value ; List1 )

returns the line number of a value from a list using a paragraph return as the line delineator

  Average rating: 3.9 (45 votes) Log in to vote

Timothy Brown   Timothy Brown
Antidote Solutions
http://www.antidotesolutions.com

Share on Facebook Share on Twitter

  Sample input:
getLine("c";"a¶b¶c¶d")
  Sample output:
3

  Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

returns the line number of a value from a list using a paragraph return as the line delineator

I substitute a valuelist for the list parameter

 

Comments

Oreste Schiavone   Oreste Schiavone, New York
Jan 21, 2009
How is this different than getitemrank
 
Agnès   Agnès, Paris
Jan 22, 2009
or List.find()

Carreful, getLine( "Orange¶Or" ; "Or" ) give 1
but perhaps is that you want.

I like this one :

ValueCount ( Left ( ¶ & _List & ¶ ;
Position ( ¶ & _List & ¶ ; ¶ & Value & ¶ ; 1 ; 1 )))

You can amenage with three parameters
like this ( _List ; Value ; Choice )
 

Log in to post comments.

 

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.

Under construction. Email me your wish list for improvements.