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

StripText (text)

Rate this function:  

  Average rating: 4.2  (37 votes)
  Discuss this Custom Function

Tom Vincent, Nearly Normal Services

Strips formatting, tabs, multiple spaces from text.

Sample Input:
StripText (Self)
Sample Output:
Clean, single-spaced text without tabs.

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


I use this all the time as an auto-enter calc for text fields that get crap pasted into them on a regular basis (email and URL fields are always coming in with underlines in that ugly blue). Just set the auto-enter calc to StripText (Self) and uncheck "Don't Replace Existing . . ."
Also great for Notes fields where users are pasting in all sorts of junk that needs to be cleaned up.
Of the few times I've seen real file corruption in FileMaker databases it has usually been bad input, like oddly formatted text or cross-platform font crap. I wrote this to help with that.
I've found that using Char () functions is more reliable and it has to be recursive for the double-space removal to work.
This iteration doesn't remove returns. Just stick another line in the Case argument to add that.
For real control, wrap the whole thing in a Filter () function, but then get checked for OCD.
NOTE: Fixed, 11/10/10, with apologies to anyone who lost time fooling around with the broken version.

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


5 most recent comments | Show all 6 comments

Sorry, that was a screwup.
I called the function "CleanText" but since there's already a "CleanText" on this board, I renamed it "StripText" and forgot about the self-references.
Thanks for catching that, it's fixed now.

Tom Vincent, Hoboken
October 14, 2010 11:28am

Sorry, I tried this a month ago and couldn't get it to work - even after repairing the self referenced name.

Thought I would give it another try. Still no go. I put it in an auto enter calc and enter some malformed text (carriage returns and tabs). As soon as I exit the field EVERYTHING disappears, not just the unwanted characters.

Jeep Watson, Baltimore
November 09, 2010 8:50pm

No really, this time it's fixed. I tested it.
I'd left out the last Case result which of course is the one that returns the cleaned up text.
That's why everything was disappearing, which is what I wish I could do right about now.

Sorry for the bother.

Tom Vincent, Hoboken
November 09, 2010 11:17pm

Works like a charm. Do not forget the
input parameter: Text

bb, Hamburg
April 13, 2015 1:36pm

Imported text copied and pasted from an emailed internet form using Outlook ultimately show as text followed by a small, hollow square in a PDF.

I have yet to identify the alien character but this custom function does not clean it from the FM field as hoped.

Any suggestions?

Peter, London
December 30, 2017 1:13am

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 4 + 7 =
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. SortList ( theList )
  (Sat, Jun 23, 8:45am)
2. HexUUIDToNum_cf (_uuid)
  (Sat, Jun 16, 1:55pm)
3. httpResponseCode ( responseHeaders )
  (Tue, Jun 12, 10:40pm)
4. FindDuplicateCharacters ( string )
  (Fri, Jun 08, 5:01pm)
5. FieldRepetitionLast ( field ; maxRepetition )
  (Wed, Jun 06, 6:05pm)
6. CountModifiedRecords ( NameTimestampField ; StartTimestamp ; EndTimestamp )
  (Mon, May 28, 8:23am)
7. JSONArrayLength ( JSONArrayStr )
  (Fri, May 25, 7:46am)
8. interpolation (y1; y2; y3; x1; x2; x3; x1y1; x2y1; x1y2; x2y2; rnd)
  (Sat, May 19, 3:55am)

RSS Feed of Custom Functions