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
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.
Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.