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 - Show more from this author
Antidote Solutions
http://www.antidotesolutions.com

Sample input:

getLine("c";"a¶b¶c¶d")

Sample output:

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

/* 
created by Tim Brown of Antidote Solutions
2009-01-17

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

Let([
v = value;
p = Position(List1; v; 1;1);
l = Left(List1; p)
];
Case(
p = 0; "does not exist";
PatternCount( l ; "¶") + 1
)
)

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, New York Jan 21, 2009
How is this different than getitemrank

		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 )

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

getLine ( value ; List1 )

Comments

Support this website.

Support this website.