Make it a calculation in define field. No waiting for loops and lookups Case(ST = "CA"; "California"; ST = "IA"; "Iowa";)
Place the new field on the layout(s) -----Original Message----- From: FileMaker Pro Discussions [mailto:[email protected]] On Behalf Of John Weinshel Sent: Monday, January 26, 2009 2:53 PM To: [email protected] Subject: Re: State calculation field? Hmm-might execute faster to build a States table with 2 fields: Full_Name and 'Code', where 'California', 'Nevada', etc. populate Full_Name, and 'CA', 'NV', etc. populate Code. Your original table would lookup the Code based on Full_Name, it would run a lot faster than running a loop, and it shouldn't take long to build the table and populate the records. John Weinshel Datagrace Vashon Island, WA ________________________________________ From: FileMaker Pro Discussions [mailto:[email protected]] On Behalf Of Bruce Button Sent: Monday, January 26, 2009 12:46 PM To: [email protected] Subject: Re: State calculation field? Melissa To do just the California records you can create a found set of all the California records (and only the California records), then change the first ST field to California, then select Records > Replace field contents (or just Ctrl =) and click "Replace" in the resulting dialog box. This would change the "CA" in all those records to "California". You would have to repeat the process for all 50 states (or however many states are represented by the students. It doesn't matter how many records there are in total; you only have to repeat the process for each state. Another way would be to set up a script which steps through the whole database and replaces each two-letter state abbreviation with the full state name, like this: Go to record/request/page [First] Loop Set Field[ST; Substitute(ST; ["CA";"California"]; ["AL";"Alabama"]; all other state substitutions in square brackets) Go to record/request/page [Next; Exit after last] End loop With the first method you enter the state codes and names as you go along; with the second you enter them all in the beginning. Of course, the script can be used over and over again without having to retype the state names and codes. By the way, it's advisable to back up your database before making the changes! Hope this helps Bruce Button Blackburn, Melissa Chappars Ms. wrote: Does anyone have a script or calculation to populate a STATE field (text; each of the 50 US states spelled out) using the two character ³ST² abbreviation from an Excel file field of downloaded student lists. For the record below which came from an Excel file, in the ³ST² field, CA came through from the Excel file. I want to generate the word California in the ³STATE² field. I can always do a search for all CAs and ³Replace Field Contents² by hand but our Dean¹s List alone has over 4,000 students.... I know I can do it in Excel with a Search and Replace but I want to do it in FileMaker. Thanks for any help you can offer. ST CA COUNTY San Diego NAME_FIRST Megan MI Elizabeth NAME_LAST Smith ADDR 2031 Arbor Dr CITY Escondido STATE ZIP 92029 DEG_DESC Bachelor of Arts DEPT_HNR UNIV_HNR Cum Laude __________ Information from ESET NOD32 Antivirus, version of virus signature database 3801 (20090126) __________ The message was checked by ESET NOD32 Antivirus. http://www.eset.com
