StateAcronym_Mex ( State )

Returns the three letter acronym for each Mexican state.

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

Ibrahim Bittar Torres - Show more from this author
Eikonsys, S.A. de C.V.
http://www.eikonsys.com

Sample input:

StateAcronym_Mex ( "Puebla" )

Sample output:

PUE

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

Case ( State = "Aguascalientes" ; "AGS" ; 
          State = "Baja California" ; "BC" ; 
          State = "Baja California Sur" ; "BCS" ; 
          State = "Chihuahua" ; "CHI" ; 
          State = "Chiapas" ; "CHS" ; 
          State = "Campeche" ; "CMP" ; 
          State = "Coahuila" ; "COA" ; 
          State = "Colima" ; "COL" ; 
          State = "Distrito Federal" ; "DF" ; 
          State = "Durango" ; "DGO" ; 
          State = "Guerrero" ; "GRO" ; 
          State = "Guanajuato" ; "GTO" ; 
          State = "Hidalgo" ; "HGO" ; 
          State = "Jalisco" ; "JAL" ; 
          State = "Michoacán" ; "MCH" ; 
          State = "Estado de México" ; "MEX" ; 
          State = "Morelos" ; "MOR" ; 
          State = "Nayarit" ; "NAY" ; 
          State = "Nuevo León" ; "NL" ; 
          State = "Oaxaca" ; "OAX" ; 
          State = "Puebla" ; "PUE" ; 
          State = "Quintana Roo" ; "QR" ; 
          State = "Querétaro" ; "QRO" ; 
          State = "Sinaloa" ; "SIN" ; 
          State = "San Luis Potosí" ; "SLP" ; 
          State = "Sonora" ; "SON" ; 
          State = "Tabasco" ; "TAB" ; 
          State = "Tlaxcala" ; "TLX" ; 
          State = "Tamaulipas" ; "TMS" ; 
          State = "Veracruz" ; "VER" ; 
          State = "Yucatán" ; "YUC" ; 
          State = "Zacatecas" ; "ZAC" )

This function is very handy if you are in México or are doing something for a Mexican company. This will return the short name for each Mexican state, which can be useful to construct addresses or in electronic invoicing.

Comments

		Lee Smith Aug 23, 2014
Your custom function did not work out of the box. Your parameter shows as â€œtateAcronym_Meâ€, and it yet it requires a field â€œStateâ€ I do not see the purpose of tateAcronym_Me. When I made a test file, I had to create both fields but only the state was needed. Perhaps a better explanation on how to set up the custom function in a file would help the reader in the future.

		Ibrahim Bittar, LeÃ³n, MÃ©xico Aug 23, 2014
Hi Lee With all due respect, you don't see the purpose because you're not Mexican :) (tongue in cheek here). Let me explain: In Mexico we use full names for states, for example, in an address we use "Guanajuato" instead of "GTO", as opposed as in the US where everybody uses the acronym. This function was created with Mexican developers in mind, because we sometimes need the short name of a state and all we have is the long name. With this function we can have both without having to write the looooong case statement every time. I hope you now see the purpose... Best regards.

		unix, Japan Aug 25, 2014
You need to write function name as StateAcronym_Mex ( State ) since State may be parameter, not field name.

		Ibrahim Bittar Torres, Eikonsys, S.A. de C.V. Aug 25, 2014
Hi Unix Thank you very much for noticing this. It has been corrected.

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

StateAcronym_Mex ( State )

Comments

Support this website.

Support this website.