Jump to content
Foipo

Function to help with import error correction.

Recommended Posts

Foipo

Here's an idea for a function in FileMaker: when you're importing names that might have slight spelling differences with the already existing ones, one might want to create a function that would compare an imported name and surname with all the available, correct ones. Then it would enter the closest match from the database at a cut off: i.e. 80% to 100% similar.

 

Does that ring a bell to anyone?

 

Do you guys think that would be a worthwhile function?

Share this post


Link to post
Share on other sites
Robert Schaub

Don't Like it. Concentrate on tightening up the data entry/. Offer possible matches as you type.

Share this post


Link to post
Share on other sites
J Wenmeekers

 

Does that ring a bell to anyone?

 

 

I use the Levenshtein algorithm for that.

Wrapped in some clever scripting and linked to a script trigger calling a popover (FM13).

 

And for some specific use we use the combination Damerau-Levenshtein distance.

 

Works like a charm.

Edited by J Wenmeekers

Share this post


Link to post
Share on other sites
Foipo
I use the Levenshtein algorithm for that.

Wrapped in some clever scripting and linked to a script trigger calling a popover (FM13).

 

And for some specific use we use the combination Damerau-Levenshtein distance.

 

Works like a charm.

 

Thanks J. Any heads up on resources for these, that is ready made plugins or functions? I am a computer scientist so I shouldn't have a problem but I am also a programmer so I 'd love some tools to work with.

Share this post


Link to post
Share on other sites
This thread is quite old. Please start a new thread rather than reviving this one.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.




×
×
  • Create New...

Important Information

Terms of Use