MagicDecoder ( theText ; theCode )

Simple substitution decoder like the Magic decoder ring found in cereal boxes

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

Geoff Wells
DataIsland Software LLC
http://www.dataisland.com

Sample input:

vku mlbeo hpxzf ixy rlnhuq xaup vku wtsg qxcd

Sample output:

the quick brown fox jumbed over the lazy dogs

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

Let ( alpha = "abcdefghijklmnopqrstuvwxyz " ;

If ( Length ( theText ) > 1;

Middle ( alpha ; Position ( theCode ; Middle ( theText ; 1 ; 1 ) ; 1 ; 1 ) ; 1 ) & MagicDecoder ( Right ( theText; Length ( theText ) - 1 ); theCode );

Middle ( alpha ; Position ( theCode ; theText ; 1; 1 ) ; 1 )

)

)

This function takes any text string encoded with the MagicEncoder function and decodes 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. Obviously you must use the same code to decode as you used to encode.

Note that case is not preserved.

Comments

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

MagicDecoder ( theText ; theCode )

Comments

Support this website.

Support this website.