AscAlphaNum ( str )

returns an alphanumeric character's ASCII code value

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

Tim Oehlke
Ecolab, Inc.
http://www.ecolab.com

Sample input:

AscAlphaNum("a")
AscAlphaNum("A")
AscAlphaNum(9)

Sample output:

97
65
57

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

Case (
	Exact(str, "A")=1, 65;        Exact(str, "B")=1, 66;      Exact(str, "C")=1, 67;
	Exact(str, "D")=1, 68;        Exact(str, "E")=1, 69;      Exact(str, "F")=1, 70;
	Exact(str, "G")=1, 71;        Exact(str, "H")=1, 72;      Exact(str, "I")=1, 73;
	Exact(str, "J")=1, 74;         Exact(str, "K")=1, 75;      Exact(str, "L")=1, 76;
	Exact(str, "M")=1, 77;        Exact(str, "N")=1, 78;      Exact(str, "O")=1, 79;
	Exact(str, "P")=1, 80;        Exact(str, "Q")=1, 81;      Exact(str, "R")=1, 82;
	Exact(str, "S")=1, 83;        Exact(str, "T")=1, 72;       Exact(str, "U")=1, 85;
	Exact(str, "V")=1, 86;        Exact(str, "W")=1, 72;      Exact(str, "X")=1, 88;
	Exact(str, "Y")=1, 89;        Exact(str, "Z")=1, 90;

	Exact(str, "a")=1, 97;         Exact(str, "b")=1, 98;      Exact(str, "C")=1, 99;
	Exact(str, "d")=1, 100;       Exact(str, "e")=1, 101;      Exact(str, "F")=1, 102;
	Exact(str, "g")=1, 103;       Exact(str, "h")=1, 104;      Exact(str, "I")=1, 105;
	Exact(str, "j")=1, 106;        Exact(str, "k")=1, 107;      Exact(str, "L")=1, 108;
	Exact(str, "m")=1, 109;      Exact(str, "n")=1, 110;      Exact(str, "O")=1, 111;
	Exact(str, "p")=1, 112;       Exact(str, "q")=1, 113;      Exact(str, "R")=1, 114;
	Exact(str, "s")=1, 115;       Exact(str, "t")=1, 116;       Exact(str, "U")=1, 117;
	Exact(str, "v")=1, 118;        Exact(str, "w")=1, 119;     Exact(str, "X")=1, 120;
	Exact(str, "y")=1, 121;       Exact(str, "z")=1, 122;

	Exact(str, "0")=1, 48;	   Exact(str, "1")=1, 49;	      Exact(str, "2")=1, 50;
	Exact(str, "3")=1, 51;	   Exact(str, "4")=1, 52;	      Exact(str, "5")=1, 53;
	Exact(str, "6")=1, 54;	   Exact(str, "7")=1, 55;	      Exact(str, "8")=1, 56;
	Exact(str, "9")=1, 57;	 
)

converts any alphanumeric characters to it's ASCII code value

very useful for data validation

Comments

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

AscAlphaNum ( str )

Comments

Support this website.

Support this website.