positionValue ( string ; searchString ; start ; occurrence )

Return the value's position in a list, including a partial match.

Average rating: 5.0 (2 votes) Log in to vote

Josh Ormond - Show more from this author
Iozax, LLC
http://iozax.com

Sample input:

positionValue ( "ABC¶DEF¶ACB¶FED" ; "A" ; 1 ; 2 )

Sample output:

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

/*************************************** 
*
*	Function Name:		positionValue ( string ; searchString ; start ; occurrence )
*	Parameters:		@string  = the full string to search against.
*					@searchString = the string to search for in @string.
*					@start = the character to start searching from.
*					@occurrence = the occurrence of the @searchString to find.
*	Purpose:			Provide the value's position, based on a partial match. Works same as the Position function.
*	Notes:			PositionValue ( "A¶C¶D¶B¶E¶F" ; "B" ; 1 ; 1 ) = 4
*	Change log:		2019-10-31 JO - Initial build.
*
*****************************************/

ValueCount ( 

	Left ( string ; Position ( string ; searchString ; start ; occurrence ) ) 

)

Sometimes I want the position of a value based on partial match. Similar to how the built-in function Position ( ) works. Simple function to just return the value position in a list.

Comments

		Nick Lightbody, Deskspace Systems Limited Jan 5, 2021
This is a efficient means of solving a frequent problem very elegantly!

		Josh Ormond, Iozax, LLC Jan 6, 2021
Thanks Nick. I was considering wrapping the list in outer carriage returns to allow for easier full-value matching also, but I was uncertain on the demand for that, give the other functions available.

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

positionValue ( string ; searchString ; start ; occurrence )

Comments

Support this website.

Support this website.