Shopping Cart

Free Newsletter
Signup

Contact me | vCard

Brian on CNN

Brian on CBS Radio

FileMaker is a registered trademark of FileMaker, Inc. in the U.S. and other countries.

FileMaker Pro Custom Functions

Search | List | Show Random | Upload | Add This to Your Site

AscAlphaNum ( str )

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

returns an alphanumeric character's ASCII code value

Sample Input:

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

Sample Output:

97
65
57

<br> <input type="button" Then cols="60" rows="15" wrap="VIRTUAL">Case ( Exact(str, "B")=1, 66; Exact(str, "C")=1, 67; Exact(str, "E")=1, 69; Exact(str, "F")=1, 70; Exact(str, "H")=1, 72; Exact(str, "I")=1, 73; Exact(str, "K")=1, 75; Exact(str, "L")=1, 76; Exact(str, "N")=1, 78; Exact(str, "O")=1, 79; Exact(str, "Q")=1, 81; Exact(str, "R")=1, 82; Exact(str, "T")=1, 72; Exact(str, "U")=1, 85; Exact(str, "W")=1, 72; Exact(str, "X")=1, 88; Exact(str, "Z")=1, 90; Exact(str, "b")=1, 98; Exact(str, "C")=1, 99; Exact(str, "e")=1, 101; Exact(str, "F")=1, 102; Exact(str, "h")=1, 104; Exact(str, "I")=1, 105; Exact(str, "k")=1, 107; Exact(str, "L")=1, 108; Exact(str, "n")=1, 110; Exact(str, "O")=1, 111; Exact(str, "q")=1, 113; Exact(str, "R")=1, 114; Exact(str, "t")=1, 116; Exact(str, "U")=1, 117; Exact(str, "w")=1, 119; Exact(str, "X")=1, 120; Exact(str, "z")=1, 122; Exact(str, "1")=1, 49; Exact(str, "2")=1, 50; Exact(str, "4")=1, 52; Exact(str, "5")=1, 53; Exact(str, "7")=1, 55; Exact(str, "8")=1, 56; value="Select All" onclick="this.form.calc.focus();this.form.calc.select();"> copy & paste into FileMaker Advanced's Edit Custom Function window.<br /></p> <input type="button" value="Copy to Clip Manager" onclick="cmcopy(intro_part1 + this.form.CF_name.value + intro_part2 + this.form.CF_params.value + intro_part3 + this.form.calc.value + outro);return false;"> if you have <a href="http://www.myfmbutler.com/clipmanager_bd.lasso" target="_blank">myFMbutler's Clip Manager</a> installed </form> <p> <b>Description:</b></p> <p>converts any alphanumeric characters to it's ASCII code value<br /> <br /> very useful for data validation</p> <p><font color="#FF0000">Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.</font></p> <p><a href="/filemaker-custom-functions/detail.php?function=start_edit&fn_id=109">This is my Custom Function and I want to edit it</a></p> </td> <td width="200" align="center" valign="top"><p align="center"><a href="javascript:document.diggForm.submit.click();">digg this page</a> | <a href="http://del.icio.us/post?url=http://www.briandunning.com/cf/109" target="_blank">del.icio.us this page</a></p> <form action="http://digg.com/submit" method="POST" name="diggForm" target="_blank" style="display:none;"> <input type="hidden" name="url" value="http://www.briandunning.com/cf/109"> <input type="hidden" name="phase" value="1"> <input type="hidden" name="randkey" value="43928978"> <input type="hidden" name="id" value="c_1"> <input type="hidden" name="title" value=""> <input type="submit" name="submit" value="submit"> </form> <table width="100%" border="0" cellpadding="10" cellspacing="1" bgcolor="#333333"> <tr> <td align="center" bgcolor="#FFFFFF"><a href="/files/Custom%20Functions.wdgt.zip"><img src="/images/cf_widget.jpg" width="134" height="146" border="0" alt="Custom Functions Widget"></a><br> <b><a href="/files/Custom%20Functions.wdgt.zip">Download the Custom Function Dashboard Widget for OS X</a></b><br> Keep all the latest Custom Functions right at your fingertips!</td> </tr> </table> <br> <table width="100%" border="0" cellpadding="10" cellspacing="1" bgcolor="#000000"> <tr> <td align="center" bgcolor="#CCCCCC"><p><b>Newest Custom Functions:</b></p> <table width="100%" border="0" cellspacing="3" cellpadding="0"> <tr valign="top"> <td align="right"><b>1.</b></td> <td align="left"><a href="/cf/841">PVofFV ( FutureVal , Interest , Term )</a></td> </tr> <tr valign="top"> <td align="right"> </td> <td align="left">(Sat, May 10, 6:52pm)</td> </tr> <tr valign="top"> <td align="right"><b>2.</b></td> <td align="left"><a href="/cf/840">Edate ( thedate ; months )</a></td> </tr> <tr valign="top"> <td align="right"> </td> <td align="left">(Sat, May 10, 5:21pm)</td> </tr> <tr valign="top"> <td align="right"><b>3.</b></td> <td align="left"><a href="/cf/839">FormatDate( DatetoFormat )</a></td> </tr> <tr valign="top"> <td align="right"> </td> <td align="left">(Thu, May 08, 6:05pm)</td> </tr> </table> <br> <a href="/filemaker-custom-functions/rss.xml"><img src="/images/xml.gif" alt="RSS Feed of Custom Functions" width="36" height="17" border="0"></a></td> </tr> </table> <br> <table width="100%" border="0" cellpadding="0" cellspacing="1" bgcolor="#000000"> <tr> <td height="20" align="center" class="boldwhite">Quick Poll...</td> </tr> <tr> <td bgcolor="#FFFFFF"><table width="100%" border="0" cellpadding="4" cellspacing="1"> <tr> <td height="40" align="center" bgcolor="#003399" class="boldwhite">Are you mainly Mac<br> or mainly Windows?</td> </tr> <tr> <td align="left" bgcolor="#E7E7E7"> • <a href="http://www.groovysurveys.com/show.php?a=1RaZMaS7MPGyWN7clgu4pA%3D%3D" target="groovy">Mac</a></td> </tr> <tr> <td align="left" bgcolor="#E7E7E7"> • <a href="http://www.groovysurveys.com/show.php?a=J8Rt5i20xFeyWN7clgu4pA%3D%3D" target="groovy">Windows</a></td> </tr> <tr> <td align="center" bgcolor="#CCCCCC"><a href="http://www.groovysurveys.com/show.php?v=OK5OKqcQvPo%3D" target="groovy"><b>View the answers</b></a></td> </tr> </table></td> </tr> </table> <br> <table width="100%" border="0" cellpadding="10" cellspacing="1" bgcolor="#000000"> <tr> <td align="center" bgcolor="#CCCCCC"><p><b><a href="/tomarket/">ToMarket</a></b></p> <p>Become a successful software entrepreneur. <a href="/tomarket/">Click here.</a></p> <p><a href="/tomarket/"><img src="/images/women-150.jpg" border="0" alt=""></a></p> </td> </tr> </table> <p align="left"><b>Custom Function Authors:</b><br> Link to all of your own custom functions on this site with the following URL:<br> http://www.briandunning.com/filemaker-custom-functions/results.php?author=Your Name Here</p>  </td> </tr> <tr> <td colspan="2" align="center" valign="top"> </td> </tr> </table>  <img src="/images/spacer2.gif" height="1" width="1" alt=""></td> </tr> <tr> <td bgcolor="#330066"> </td> <td align="center"> </td> </tr> </table> <div id="dropin" style="position: absolute; visibility: hidden; left: 142px; top: 71px; width: 463px; height: 294px; border-top: 3px solid #000; border-bottom: 3px solid #000; border-left: 3px solid #000; border-right: 3px solid #000; background-color: #FFF;"> <table width="100%" border="0" cellspacing="0" cellpadding="5"> <tr> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> </tr> <tr> <td> </td> <td colspan="2"><a href="/tomarket/"><img src="/images/tomarket_big.gif" alt="ToMarket" width="232" height="40" border="0" /></a></td> <td nowrap><a href="#" onclick="dismissbox();return false">[ Close Window ]</a></td> <td> </td> </tr> <tr> <td> </td> <td colspan="3">The class that teaches you how to successfully sell your FileMaker Pro solution as a professional shrinkwrapped software application.</td> <td> </td> </tr> <tr> <td> </td> <td align="right" valign="middle" nowrap><h2><br /> Let's Meet in Person</h2> <p>Sunday, August 13 2006, Orlando FL<br> Courtyard Orlando International Drive </p></td> <td colspan="2" valign="middle"><a href="/tomarket/"><img src="/chunks/brian.gif" alt="Brian" width="50" height="72" border="0"></a></td> <td> </td> </tr> <tr> <td> </td> <td colspan="3"><i>Don't miss this most important day of the Developer Conference. </i><a href="/tomarket/">Please click here for complete details and online registration. </a></td> <td> </td> </tr> <tr> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> </tr> </table> </div> </body></html>