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.

Under construction. Email me your wish list for improvements.