Code - Custom Function
USStateName ( StateAbbrev )
BrianDunning.com, Brian Dunning http://www.briandunning.com/filemaker-custom-functions/list.php
Rate this function: Average rating: 2.0 (3 votes) Discuss this Custom FunctionEric Troedsson, NC Credit Repair
http://www.nccreditrepair.com
Converts the Postal Code of a US State to its two-letter Postal abbreviation
==================== SAMPLE INPUT AND OUTPUT ====================
INPUT
StateAbbrev = USStateName
OUTPUT
NC=North Carolina
==================== DESCRIPTION ====================
We use this function often in our credit repair business' custom-built FileMaker application when generating documentation for the client. A simple but useful function. Thanks!
==================== CUSTOM FUNCTION ====================
Case ( StateAbbrev= "AL" ; "Alabama" ;
StateAbbrev= "AK" ; "Alaska" ;
StateAbbrev= "AZ" ; "Arizona" ;
StateAbbrev= "AR" ; "Arkansas" ;
StateAbbrev= "CA" ; "California" ;
StateAbbrev= "CO" ; "Colorado" ;
StateAbbrev= "CT" ; "Connecticut" ;
StateAbbrev= "DE" ; "Delaware" ;
StateAbbrev= "FL" ; "Florida" ;
StateAbbrev= "GA" ; "Georgia" ;
StateAbbrev= "HI" ; "Hawaii" ;
StateAbbrev= "ID" ; "Idaho" ;
StateAbbrev= "IL" ; "Illinois" ;
StateAbbrev= "IN" ; "Indiana" ;
StateAbbrev= "IA" ; "Iowa" ;
StateAbbrev= "KS" ; "Kansas" ;
StateAbbrev= "KY" ; "Kentucky" ;
StateAbbrev= "LA" ; "Louisiana" ;
StateAbbrev= "ME" ; "Maine" ;
StateAbbrev= "MD" ; "Maryland" ;
StateAbbrev= "MA" ; "Massachusetts" ;
StateAbbrev= "MI" ; "Michigan" ;
StateAbbrev= "MN" ; "Minnesota" ;
StateAbbrev= "MS" ; "Mississippi" ;
StateAbbrev= "MO" ; "Missouri" ;
StateAbbrev= "MT" ; "Montana" ;
StateAbbrev= "NE" ; "Nebraska" ;
StateAbbrev= "NV" ; "Nevada" ;
StateAbbrev= "NH" ; "New Hampshire" ;
StateAbbrev= "NJ" ; "New Jersey" ;
StateAbbrev= "NM" ; "New Mexico" ;
StateAbbrev= "NY" ; "New York" ;
StateAbbrev= "NC" ; "North Carolina" ;
StateAbbrev= "ND" ; "North Dakota" ;
StateAbbrev= "OH" ; "Ohio" ;
StateAbbrev= "OK" ; "Oklahoma" ;
StateAbbrev= "OR" ; "Oregon" ;
StateAbbrev= "PA" ; "Pennsylvania" ;
StateAbbrev= "RI" ; "Rhode Island" ;
StateAbbrev= "SC" ; "South Carolina" ;
StateAbbrev= "SD" ; "South Dakota" ;
StateAbbrev= "TN" ; "Tennessee" ;
StateAbbrev= "TX" ; "Texas" ;
StateAbbrev= "UT" ; "Utah" ;
StateAbbrev= "VT" ; "Vermont" ;
StateAbbrev= "VA" ; "Virginia" ;
StateAbbrev= "WA" ; "Washington" ;
StateAbbrev= "WV" ; "West Virginia" ;
StateAbbrev= "WI" ; "Wisconsin" ;
StateAbbrev= "WY" ; "Wyoming" )
Referring URL: 'http://www.briandunning.com/cf/1121'
Keywords: ''
ClipManager:

