Brian Dunning's FileMaker Custom Functions

Mac_to_ASCII ( text )

Translates any text encoded in Mac OS Roman to plain US-ASCII encoded text

  Average rating: 4.6 (25 votes) Log in to vote

Andreas Fischlin   Andreas Fischlin
ETH Zurich, Systems Ecology

Share on Facebook Share on Twitter

  Sample input:
Mac_to_ASCII ( "2° C is according to Krüger et al., 2009")
  Sample output:
2 degree C is according to Krueger et al., 2009

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

MacOS Roman characters above ordinal decimal number 127 up to 255 can not be encoded in US-ASCII. This routine nevertheless does that by matching the characters to an alternative character or if none exists to a small string, possibly enclosed blanks or with underscores. Ex.: Umlaute are translated from "Ü" to "Ue", "ä" to "ae", or accents are dropped, e.g. "é" to "e", or "°" is translated into " degree", or "¶" becomes "_EOL_". Of course some complicated cases, as the last example demonstrates, may not always look good, depending on circumstances. Feel free to edit this function accordingly. Note, this function attempts to translate ALL Mac OS Roman characters (for a definition of this character set see e.g. or



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.