Software Venture Consulting

FileMaker Pro downloads & Resources
FileMaker Custom Functions
FileMaker Web Viewer Examples
FileMaker Pro & Lasso Consulting
Training
FileMaker Books
FileMaker Articles
FileMaker Error Reference

Free Web Tools
Free FileMaker Tools

Personal Pages
Videos
Adventures
Links

Shopping Cart
Shopping Cart

Search:

Free Newsletter
Signup


Contact


Privacy Policy



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

 

 FileMaker Pro Custom Functions

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

GetCountryFromCountryCode ( CountryCode )

Rate this function:  

RatingRatingRatingRatingRating
  Average rating: 3.7  (51 votes)
  Discuss this Custom Function

Andy Knasinski, nrg Software, LLC.
http://www.nrgsoft.com

Get full country name from country code

Sample Input:
GetCountryFromCountryCode ( "YE" )
Sample Output:
Yemen


 Then copy & paste into FileMaker Advanced's Edit Custom Function window.

Click here to copy To Clip Manager if you have myFMbutler's Clip Manager installed

Description:

Convert ISO country code to full country name

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

This is my Custom Function and I want to edit it

Discuss:

Great idea, faster and easier to use than related table (unless you need the country names in multiple languages).

Why are all country names in all upper case? We can always use Upper if we want it this way, but if we want the country name with correct case, this custom function will fail.

I would also suggest adding last update date in the function as a comment because this kind of function can be obsoleted by political changes.

HOnza, Prague
April 26, 2011 11:03pm

The ISO 3166-1 lists all have the names a UPPERcase interestingly, but this list is not correct to it.

http://www.iso.org/iso/country_codes/iso_3166_code_lists/iso-3166-1_ decoding_table.htm

John Renfrew, birmingham UK
May 24, 2011 11:02am

ISO lists the country names in uppercase. Just posted updated list with modified date and comments in script with country names in proper case, you can now convert on your own to uppercase. While the ISO list is helpful, we work with the ship carriers and have had to create our own conversion tables from ISO to carrier names for compliance in our certified shipping solutions for USPS, UPS and FedEx.

Andy, NRG
May 24, 2011 11:27am

FileMaker Pro 11 Advanced chokes on this line:

CountryCode = "ST" ; "S„o TomÈ and PrÌncipe" ;

I replaced the accented name with "Sao Tome and Principe" from Wikipedia's ISO 31166-1 alpha-2 page:

http://en.wikipedia.org/wiki/ISO_3166-1_alpha-2

Ward, Massachusetts, USA
November 30, 2012 12:49pm

Make a comment about this Custom Function (please try to keep it brief & to the point). Anyone can post:

Your Name:
City/Location:
Comment:
characters left. If you paste in more than 1500 characters, it will be truncated. Discuss the function - advertisements and other useless posts will be deleted.
Answer 6 + 7 =
Search for Custom Functions:

Custom Functions Widget
Download the Custom Function Dashboard Widget for OS X
Keep all the latest Custom Functions right at your fingertips!

Newest Custom Functions:

1. NumberToHexadecimal(NumberValue)
  (Fri, Dec 08, 8:54am)
2. Get_BaseTable
  (Thu, Dec 07, 4:27pm)
3. JSONCreateVarsFromKeys ( json ; namespace )
  (Wed, Dec 06, 8:21pm)
4. GetTableNzme ( field )
  (Tue, Dec 05, 9:16pm)
5. TimeFormatAsText ( theTime )
  (Mon, Nov 13, 1:59pm)
6. ParseWebValueList( text )
  (Thu, Nov 02, 9:52am)
7. SVG_HTML_to_Text ( _svg_text ; _orig_text ;
  (Wed, Oct 25, 4:17am)
8. decFromHex ( hexValue )
  (Mon, Oct 16, 12:34pm)

RSS Feed of Custom Functions