Brian Dunning's FileMaker Custom Functions

MatchFirstName ( Name1, Name2, ShowMatchList )

Used to help match/merge duplicate client entries (should always try matching with email/phone/birthdate first)

  Be the first to rate this function Log in to vote

Kyle Williams   Kyle Williams - Show more from this author
Dreamclinic Massage
http://www.dreamclinic.com

Share on Facebook Share on Twitter

  Sample input:
MatchFirstName ( "Christina", "Tina", 0 )
MatchFirstName ( "Kevin", "Kyle", 0 )
MatchFirstName ( "Phillip", "", 1 )
  Sample output:
1
0
"PHILLIP¶PHIL" (Return delimited list of found names)

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

PURPOSE: Help to eliminate duplicative client records, provides another level of matching after email, phone number, & birthday
NOTES: Function will try to match with the first name of each row first (name), if no found matches, it will try matching with a nickname/alternative name.
If still no match is found, it will use the given Name1 and try to match it with Name2
Name1 is the source name, Name2 is the name you're trying to match it with. The result is boolean.
If you would like to see what names it is returning from Name1, enter a 1 for "ShowMatchValues" (useful for troubleshooting)

 

Comments

Kyle Williams   Kyle Williams, Dreamclinic Massage
Sep 1, 2019
If you have any names or alternative names I'm missing, please post them so I can add them to this function, Thank you for your help :)
 

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.

Support this website.

This library has been a free commmunity resource for FileMaker users and developers for 15 years. It receives no funding and has no advertisements. If it has helped you out, I'd really appreciate it if you could contribute whatever you think it's worth: