Alpha2Int ( Alpha )

Converts Alpha string to its integral equivalent

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

JT Hughes
Queuedom
http://notapplicable.com

Sample input:

Alpha2Int ( "ABC" )

Sample output:

731

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

// Alpha2Int
// by JT Hughes aka -Queue-

Case ( Length( Alpha ) ; 

    // Converts leftmost character in Alpha to its numerical equivalent, then multiplies the result by 26 ^ ( length of Alpha string - 1 )
    
    Position ( "ABCDEFGHIJKLMNOPQRSTUVWXYZ" ; Left ( Alpha ; 1 ) ; 0 ; 1 ) * 26 ^ ( Length ( Alpha ) - 1 ) + 

    // Removes the first character of the string and passes it to the function, recursively

    Alpha2Int ( Right ( Alpha ; Length ( Alpha ) - 1 ) )
)

// 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

Comments

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

Alpha2Int ( Alpha )

Comments

Support this website.

Support this website.