Brian Dunning's FileMaker Custom Functions

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   Jim Main
Main Solutions

Share on Facebook Share on Twitter

  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)

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.



Log in to post comments.


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

Support this website.

This library has been a free commmunity resource for FileMaker users and developers for 16 years. It receives no funding and has no advertisements. If it has helped you out, I'd really appreciate it if you could contribute whatever you think it's worth: