ReverseAlphabet

Helpful to dynamically sort ascending or descending by simple toggle

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

Ugo Di Luca - Show more from this author
DLSYSTEMS
http://www.dlsystems.fr

Sample input:

ReverseAlphabet(TheText)

Sample output:

ReverseAlphabet("Brian Dunning") returns

"yirzm wfmmrmt"

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

Substitute( Upper(TheText); ["A"; "z"]; ["B"; "y"]; ["C"; "x"]; ["D"; "w"]; ["E"; "v"]; ["F"; "u"] ; ["G"; "t"]; ["H"; "s"]; ["I"; "r"]; ["J"; "q"]; ["K"; "p"]; ["L"; "o"]; ["M"; "n"]; ["N"; "m"]; ["O"; "l"]; ["P"; "k"]; ["Q"; "j"]; ["R"; "i"]; ["S"; "h"]; ["T"; "g"]; ["U"; "f"]; ["V"; "e"]; ["W"; "d"]; ["X"; "c"]; ["Y"; "b"]; ["Z"; "a"] )

Used in the PortalSortKey (parameter;PortalFieldNames) Custom Function, and can be used for any sort procedure where instead of involving an ascending or descending script, you may only use a calculation for that, switching order on request

Comments

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

ReverseAlphabet

Comments

Support this website.

Support this website.