Int2Alpha ( Integer )

Converts an integer to its alphabetic equivalent

Average rating: 3.9 (38 votes) Log in to vote

JT Hughes
Queuedom
http://notapplicable.com

Sample input:

Reverse ( Int2Alpha ( 745 ) )

Sample output:

ABQ

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

//Int2Alpha
//by JT Hughes aka -Queue-

Case ( Integer > 0 ; // terminates if a number less than 1 is entered or Div ( Integer - 1 ; 26 ) is less than 1

    Middle( "ABCDEFGHIJKLMNOPQRSTUVWXYZ" ; Mod ( Integer - 1 ; 26 ) + 1 ; 1 ) // Returns alphabetic equivalent of the remainer of Integer less one, divided by 26, plus 1

    & Int2Alpha ( Div ( Integer - 1 ; 26 ) ) // Passes integral result of Integer less one, divided by 26, to function, recursively

// Reverse function is then called in field definition to reverse order of characters

)

// SAMPLE CONVERSION FOR Integer = 1234

// FIRST ITERATION

// Letter = Mod ( 1234 - 1 ; 26 ) + 1 = 12 -> "L"
// Integer => Div ( 1234 - 1 ; 26 ) = 47

// SECOND ITERATION

// Letter &=> Mod ( 47 - 1 ; 26 ) + 1 = 21 -> "U"
// Integer => Div ( 47 - 1 ; 26 ) = 1

// THIRD ITERATION

// Letter &=> Mod ( 1 - 1 ; 26 ) + 1 = 1 -> "A"
// Integer => Div ( 1 - 1 ; 26 ) = 0

// Letters = "LUA"
// Reverse( "LUA" ) => "AUL"

Comments

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

Int2Alpha ( Integer )

Comments

Support this website.

Support this website.