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
