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
2Geckos Consulting, LLC
www.2geckos.com

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)

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

Case(  PatternCount ( text ; "body>" ) > 1 ;          // Remove everything except the BODY of the HTML
               Let( [ BodyStart = Position( Text ; "<body>" ; 1 ; 1 )+6 ; BodyLen = Position ( Text ; "</body>" ; 1 ; 1 ) - BodyStart  ]  ;
           TrimAll ( Middle ( Text ; BodyStart ; BodyLen  ) ; 1 ; 2 )  
                ) ;

     // The ">" character at the beginning indicates a comment
Left ( text ; 1 ) = ">" ; TextColor ( text ; RGB(153;102;255) ) ;    

// Remove all other formatting
Let( [ 
text = GetAsText (  text ) ;
text = Filter ( text ; "ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklomnopqrstuvwxyz1234567890 ¶+=-_*&%$#@!{})(:;<>,.?/" ) ;
text = TextSizeRemove ( text ) ;
text = TextFontRemove ( text ) ;
text = TextColorRemove ( text ) ;
text = TextStyleRemove ( text ; AllStyles ) ;
text = TrimAll ( text ; 1 ; 2 )  ;

text = Substitute(  text ; [ "  " ; " " ] ; [ "¶¶¶" ; "¶" ]  ) 
] ; 

text 
)
)

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

Comments

		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.

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

StripReserved ( text )

Comments

Support this website.

Support this website.