WhichValuesPlus ( values ; match ; start ; sep )

Find which values in a list match a given value

Average rating: 4.7 (28 votes) Log in to vote

Tim Anderson - Show more from this author
Tim Anderson Group

Sample input:

WhichValuesPlus("1¶2¶5¶3¶1¶4¶1¶5¶6¶7¶8¶2¶1¶3¶5";"1";1;" v")

Sample output:

v1 v5 v7 v13

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

/*
Which Values match a specified Value 

Author: Tim Anderson

Format: WhichValuesPlus ( values ; match ; start ; sep )

This returns a string of the value numbers of all 'values' 
that are the same as 'match' separated by 'sep'. 

'start' is included to allow interation, and to give you control
over where to start the search - by default use 1

I have tried to remove the leading 'sep' but cannot find a 
way - functions on _result don't seem to work. Suggestions
welcome! 
*/


Let([_final=ValueCount(values)+1;
       _slength=Length(sep);  
      _result=


Case(start  <  _final;
    Case(GetValue(values;start)=match;sep & start;"")  & WhichValuesPlus(values;match;start+1;sep)
)
];
_result

)

Which Values match a specified Value

Author: Tim Anderson

Format: WhichValuesPlus ( values ; match ; start ; sep )

This returns a string of the value numbers of all 'values'
that are the same as 'match' separated by 'sep'.

'start' is included to allow interation, and to give you control
over where to start the search - by default use 1

I have tried to remove the leading 'sep' but cannot find a
way - functions on _result don't seem to work. Suggestions
welcome!

Comments

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

WhichValuesPlus ( values ; match ; start ; sep )

Comments

Support this website.

Support this website.