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

StripText (text)

Rate this function:  

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

Tom Vincent, Nearly Normal Services
http://www.nearlynormalservices.com

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.

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

Description:

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

This is my Custom Function and I want to edit it

Discuss:

Unless I am missing something obvious, my FMPA 10 can't figure out on its own what CleanText is.

Matt Wills, Vermont
October 14, 2010 10:56am

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

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

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 8 + 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. 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