|
Alpha2Int ( Alpha )
JT Hughes, Queuedom
http://notapplicable.com
Converts Alpha string to its integral equivalent
Sample Input:
| Alpha2Int ( "ABC" ) |
|
Sample Output:
|
Description:
// SAMPLE CONVERSION FOR Alpha = "ABC"
// FIRST ITERATION
// Alpha = "ABC"
// Integer => Position ( "ABCDEFGHIJKLMNOPQRSTUVWXYZ" ; "A" ; 0 ; 1 ) * 26 ^ ( 3 - 1 ) = 1 * 26 ^ 2 = 676
// SECOND ITERATION
// Alpha => "BC"
// Integer +=> Position ( "ABCDEFGHIJKLMNOPQRSTUVWXYZ" ; "B" ; 0 ; 1 ) * 26 ^ ( 2 - 1 ) = 2 * 26 ^ 1 = 52
// THIRD ITERATION
// Alpha = "C"
// Integer +=> Position ( "ABCDEFGHIJKLMNOPQRSTUVWXYZ" ; "C" ; 0 ; 1 ) * 26 ^ ( 1 - 1 ) = 3 * 26 ^ 0 = 3
// Integer = 676 + 52 + 3 = 731
Note: these functions are not guaranteed
or supported by BrianDunning.com. Please contact the individual
developer with any questions or problems.
This is my Custom Function and I want to
edit it
|
digg this page | del.icio.us this page
Newest Custom Functions:
 |
Custom Function Authors:
Link to all of your own custom functions on this site with the following URL:
http://www.briandunning.com/filemaker-custom-functions/results.php?author=Your
Name Here
|
