Brian Dunning's FileMaker Custom Functions

MagicEncoder ( theText ; theCode )

A simple substitution encoder like the Magic decoder ring in cereal boxes.

  Average rating: 4.0 (32 votes) Log in to vote

Geoff Wells   Geoff Wells
DataIsland Software LLC

Share on Facebook Share on Twitter

  Sample input:
The quick brown fox jumbed over the lazy dogs
  Sample output:
vku mlbeo hpxzf ixy rlnhuq xaup vku wtsg qxcd

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

This function takes any text string and encodes it based on the position of letters in the "theCode" string. The example uses theCode "thequickbrownfxjmpdvlazygs ". Note the space at the end of the string. The space can be placed anywhere and will be encoded as the matching letter in the "alpha" string. To work properly both the alpha string and theCode must contain all the letters present in theText.

Use the MagicDecoder funtion to read the encoded string. Note that case is not preserved.



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: