Unformat ( text ) Unformat ( text ) Unformat ( text )

Removes all text formatting (requires the SubstituteRange function also)

Average rating: 4.2 (34 votes) Log in to vote

Jim Main
Main Solutions
http://www.mainsolutions.org

Sample input:

AnyText (formatted with style, size, color, or particular font)

Sample output:

AnyText (with no style, size, color, or font formatting)

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

SubstituteRange(
Substitute(
GetAsCSS ( text )

; ["ı"; "ı"]
; [""; ""]
; ["ﬁ"; "ﬁ"]
; ["ﬂ"; "ﬂ"]
; ["ˇ"; "ˇ"]
; ["˘"; "˘"]
; ["˙"; "˙"]
; ["˚"; "˚"]
; ["˛"; "˛"]
; ["˝"; "˝"]
; ["∆"; "∆"]
; ["	"; "	"]
; ["á"; "á"]
; ["Á"; "Á"]
; ["â"; "â"]
; [""; "Â"]
; ["æ"; "æ"]
; ["Æ"; "Æ"]
; ["&"; "&"]
; ["å"; "å"]
; ["Å"; "Å"]
; ["≈"; "≈"]
; ["ã"; "ã"]
; ["Ã"; "Ã"]
; ["ä"; "ä"]
; ["Ä"; "Ä"]
; ["„"; "„"]
; ["<BR>"; "¶"]
; ["•"; "•"]
; ["ç"; "ç"]
; ["Ç"; "Ç"]
; ["¸"; "¸"]
; ["¢"; "¢"]
; ["©"; "©"]
; ["‡"; "‡"]
; ["†"; "†"]
; ["°"; "°"]
; ["÷"; "÷"]
; ["é"; "é"]
; ["É"; "É"]
; ["ê"; "ê"]
; ["Ê"; "Ê"]
; ["ë"; "ë"]
; ["Ë"; "Ë"]
; ["€"; "€"]
; ["ƒ"; "ƒ"]
; ["⁄"; "⁄"]
; ["≥"; "≥"]
; [">"; ">"]
; ["…"; "…"]
; ["Í"; "Í"]
; ["í"; "í"]
; ["Í"; "Í"]
; ["î"; "î"]
; ["Î"; "Î"]
; ["¡"; "¡"]
; ["∫"; "∫"]
; ["¿"; "¿"]
; ["ï"; "ï"]
; ["Ï"; "Ï"]
; ["«"; "«"]
; ["“"; "“"]
; ["≤"; "≤"]
; ["◊"; "◊"]
; ["‹"; "‹"]
; ["‘"; "‘"]
; ["<"; "<"]
; ["¯"; "¯"]
; ["—"; "—"]
; ["µ"; "µ"]
; ["·"; "·"]
; ["–"; "–"]
; ["≠"; "≠"]
; ["¬"; "¬"]
; ["ñ"; "ñ"]
; ["Ñ"; "Ñ"]
; ["ó"; "ó"]
; ["Ó"; "Ó"]
; ["ô"; "ô"]
; ["Ô"; "Ô"]
; ["œ"; "œ"]
; ["Œ"; "Œ"]
; ["Ò"; "Ò"]
; ["Ω"; "Ω"]
; ["ª"; "ª"]
; ["º"; "º"]
; ["ø"; "ø"]
; ["Ø"; "Ø"]
; ["õ"; "õ"]
; ["Õ"; "Õ"]
; ["ö"; "ö"]
; ["Ö"; "Ö"]
; ["¶"; "¶"]
; ["∂"; "∂"]
; ["‰"; "‰"]
; ["π"; "π"]
; ["±"; "±"]
; ["£"; "£"]
; ["∏"; "∏"]
; ["∝"; "∞"]
; ["""; "“"]
; ["√"; "√"]
; ["»"; "»"]
; ["”"; "”"]
; ["®"; "®"]
; ["›"; "›"]
; ["’"; "’"]
; ["‚"; "‚"]
; ["§"; "§"]
; ["∑"; "∑"]
; ["ß"; "ß"]
; ["™"; "™"]
; ["ú"; "ú"]
; ["Ú"; "Ú"]
; ["û"; "û"]
; ["Û"; "Û"]
; ["ü"; "ü"]
; ["Ü"; "Ü"]
; ["¥"; "¥"]
; ["</SPAN> ¶"; ""]
)
; "<SPAN"; ">"; "" )

It used to be that running a calculation on a field deformatted the resulting text. With Filemaker 7 there is no simple way to remove all formatting from a field, which presents a real nuisance with copy/pasting text.

The 'GetAsCSS' function translates all field formatting into XML tags. This function uses 'GetAsCSS', and another custom function 'SubstituteRange' which removes the resulting tags, and finally reverts some special characters that 'GetAsCSS' translates.

You will need to first create the custom function 'SubstituteRange' listed on this site.

Comments

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

Unformat ( text ) Unformat ( text ) Unformat ( text )

Comments

Support this website.

Support this website.