Brian Dunning's FileMaker Custom Functions

StripReserved ( text )

Cleans text of special characters, colors, fonts, sizes, spaces, styles, and characters that may cause errors

  Average rating: 4.6 (21 votes) Log in to vote

Roger Biel   Roger Biel
2Geckos Consulting, LLC
www.2geckos.com

Share on Facebook Share on Twitter

  Sample input:
StripReserved ( "∑Text₪maycontain unusable₠haracters₡" )
  Sample output:
Text may contain unusable characters

  Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

Cleans text of special characters, colors, fonts, sizes, and styles

 

Comments

Scott C   Scott C, Saluda, North Carolina
Nov 5, 2015
I get an error, "An Operator (e.g. +, -, *,...) is expected here."

FileMaker highlights "text .. at the end of this string as the problem area.

BodyLen = Position ( Text ; "<script type="text/

I'm using FMPA v 14.0.3.
 

Log in to post comments.

 

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

Under construction. Email me your wish list for improvements.