Software Venture Consulting

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

Free Web Tools
Free FileMaker Tools

Personal Pages
Videos
Adventures
Links

Shopping Cart
Shopping Cart

Search:

Free Newsletter
Signup


Contact


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:  

RatingRatingRatingRatingRating
  Average rating: 3.9  (44 votes)
  Discuss this Custom Function

Ed Scott, Scott Resources
http://scott-resources.com

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.

Click here to copy To Clip Manager if you have myFMbutler's Clip Manager installed

Description:

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 BrianDunning.com. Please contact the individual developer with any questions or problems.

This is my Custom Function and I want to edit it

Discuss:

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:
City/Location:
Comment:
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 3 + 5 =
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. decFromHex ( hexValue )
  (Mon, Oct 16, 12:34pm)
2. MonthYearList ( startmonth ; startyear ; numbermonth ; short )
  (Mon, Oct 16, 3:38am)
3. ErrorDescription ( errorNumber )
  (Wed, Sep 27, 2:51am)
4. decodeEntities (text)
  (Wed, Sep 27, 1:22am)
5. HexidecimalToNumber ( HexidecimalValue ; counter )
  (Mon, Sep 25, 12:39pm)
6. FixedFieldConverter ( Fieldname ; f1 ; f2 ; f3 ; f4 ; f5 ; f6 ; f7 ; f8 ; f9 ; f10 ; f11 ; f12 ; f13 ; f14 ; f15 ; f16 ; f17 ; f18 ; f1
  (Fri, Sep 15, 12:34pm)
7. ShannonEntropy ( text )
  (Thu, Sep 07, 5:59am)
8. LetterCount ( text ; summary )
  (Thu, Sep 07, 5:53am)

RSS Feed of Custom Functions