Software Venture Consulting

FileMaker Pro downloads & Resources
FileMaker Custom Functions
FileMaker Web Viewer Examples
FileMaker Pro & Lasso Consulting
FileMaker Books
FileMaker Articles
FileMaker Error Reference

Free Web Tools
Free FileMaker Tools

Personal Pages

Shopping Cart
Shopping Cart


Free Newsletter


Privacy Policy

FileMaker is a registered trademark of FileMaker, Inc. in the U.S. and other countries.


 FileMaker Pro Custom Functions

List  |  Show Random  |  Upload  |  Add This to Your Site

OvertypeMistakes ( text ; fixList )

Rate this function:  

  Average rating: 3.8  (44 votes)
  Discuss this Custom Function

Ed Scott, Scott Resources

Text-input word corrector for upper/lower case typos

Sample Input:
apple has sold ipads in the ussr and nyc after designing components with autocad.
Sample Output:
Apple has sold iPads in the USSR and NYC after designing components with AutoCAD.

 Then copy & paste into FileMaker Advanced's Edit Custom Function window.


Written as a triggered script originally, then customer needed it to work in Instant Web Publishing, so I re-wrote it as a recursive custom function.

This is a recursive function to correct case-related typos in textual data-entry fields. It was requested by a fellow developer whose customer wanted a way to automatically clean up data entries sloppily typed in by Instant Web Publishing users. Parsing is accomplished word-by-word rather than character-by-character.

The correctly typed "fixList" parameter may be easily maintained as a return-delimited-list global field in a Preferences table. The function can (should) be invoked by defining the "text" input field as an auto-calculation that recalculates itself upon field exit. The function is implemented as a recursive loop as limited by the number of words in the calling "text" parameter, and a nested loop within that loop as limited by the number of words-to-fix in the "fixList" parameter. When every individual word in the "text" input has been compared to every individual word in the "fixList" parameter (and modified as-needed using a Substitute function), the function then exits via the second Let statement which first nulls out (destroys) the global variables (i.e., $$...) and then returns the "fixed-text" local (i.e., exists only within the custom function) variable.

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

This is my Custom Function and I want to edit it


Could you give an example of the Fixlist, I am not able to reproduce your results

Hans Nagelgast, Oss, The Netherlands
May 25, 2014 12:28am

OK, well I have figured it out. The Fixlist only contains the correctly spelled words and the input text simply replaces these values. Thanks, nice function.

Hans Nagelgast, Oss, The Netherlands
May 25, 2014 12:42am

Make a comment about this Custom Function (please try to keep it brief & to the point). Anyone can post:

Your Name:
characters left. If you paste in more than 1500 characters, it will be truncated. Discuss the function - advertisements and other useless posts will be deleted.
Answer 7 + 4 =
Search for Custom Functions:

Custom Functions Widget
Download the Custom Function Dashboard Widget for OS X
Keep all the latest Custom Functions right at your fingertips!

Newest Custom Functions:

1. HexUUIDToNum_cf (_uuid)
  (Sat, Jun 16, 1:55pm)
2. httpResponseCode ( responseHeaders )
  (Tue, Jun 12, 10:40pm)
3. FindDuplicateCharacters ( string )
  (Fri, Jun 08, 5:01pm)
4. FieldRepetitionLast ( field ; maxRepetition )
  (Wed, Jun 06, 6:05pm)
5. CountModifiedRecords ( NameTimestampField ; StartTimestamp ; EndTimestamp )
  (Mon, May 28, 8:23am)
6. JSONArrayLength ( JSONArrayStr )
  (Fri, May 25, 7:46am)
7. interpolation (y1; y2; y3; x1; x2; x3; x1y1; x2y1; x1y2; x2y2; rnd)
  (Sat, May 19, 3:55am)
8. @JSONFormatElements ( json )
  (Tue, May 15, 3:31am)

RSS Feed of Custom Functions