MatchFirstName_Multi ( Name1, Name2, ShowMatchList )

Match Multiple first names.

Be the first to rate this function Log in to vote

Kyle Williams - Show more from this author
Augusto Digital
https://www.youtube.com/channel/UCpJlB7cmVNMjbjgY96MEsng

Sample input:

MatchFirstName_Multi ( "Chris (Christina)", "Tina", 0 )

Sample output:

1 //Boolean Value

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

//Author:  Kyle Williams
//DATE:    9/1/2019
//Dependencies:  Kyle's other CF: "MatchFirstName"

Let ( [
//ShowMatchList = 1;

	text =Name1
	;text = Filter( Upper(text); "ABCDEFGHIJKLMNOPQRSTUVWXYZ ")
	;text = Substitute(text; " "; ¶  )
	;_list = 
SortValues ( UniqueValues ( 
List(
 If(IsEmpty(GetValue(text; 1));"";MatchFirstName ( GetValue(text; 1) ; "" ; 1 ))
;If(IsEmpty(GetValue(text; 2));"";MatchFirstName ( GetValue(text; 2) ; "" ; 1 ))
;If(IsEmpty(GetValue(text; 3));"";MatchFirstName ( GetValue(text; 3) ; "" ; 1 ))
)))
;_list = If ( IsEmpty ( GetValue ( _list; 1 ) ); Right( _list; Length( _list ) - 1 ); _list )

	;text2 = Name2
	;text2 = Filter( Upper(text2); "ABCDEFGHIJKLMNOPQRSTUVWXYZ ")
	;text2 = Substitute(text2; " "; ¶  )
	;_list2 = 
SortValues ( UniqueValues ( 
List(
 If(IsEmpty(GetValue(text2; 1));"";MatchFirstName ( GetValue(text2; 1) ; "" ; 1 ))
;If(IsEmpty(GetValue(text2; 2));"";MatchFirstName ( GetValue(text2; 2) ; "" ; 1 ))
;If(IsEmpty(GetValue(text2; 3));"";MatchFirstName ( GetValue(text2; 3) ; "" ; 1 ))
)))
;_list2 = If ( IsEmpty ( GetValue ( _list2; 1 ) ); Right( _list2; Length( _list2 ) - 1 ); _list2 )
];
If(ShowMatchList; _list; ValueCount ( FilterValues ( _list ; _list2 )) > 0 )
)

To be used with my other custom function "MatchFirstName" to use a combination of names in the first name field to match up with another field (Each field can contain up to 3 names)

Comments

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

MatchFirstName_Multi ( Name1, Name2, ShowMatchList )

Comments

Support this website.

Support this website.