What, in your data, tells you which values to replace with which? Need to know that in order to set up the script.
Replace Field Contents can be used to do these kind of batch updates. If you first perform a find to pull up just the fields to be changed, this can be done more quickly by performing the operation on a smaller set of records.
Actually now that I think about it, it is one field that has several different names in it. They are always the same. There are 6 names but the six are not what I need so I want to replace with another name. Its a zone, so its coming in with WA OR AL and I need it to say North West then go to the next set of names like CA NV and replace with South West.
Sorry for the previous bad example. Trying to make it simple.
The method is the same either way, as long as the naems are listed in exactly the same order in each case. WA OR AL in one record and AL WA OR in another will make this much more complicated, but it can still be done.
You can use the Replace Field Contents with the calculation option to update all newly imported records. Us a calculation like this:
Case ( YourTable::Field = "WA OR AL" ; "Northwest" ;
YourTable::Field = "CA NV AZ" ; "Southwest"
/* else */ yourTable::field
) // case
This depends on an exact match of the values in the field to the text in quotes. The last clause (else) insures that if there is no match at all, the data is left unchanged. I've assumed a space between each character. If this is a return delimitted list of values use ¶ between each listed value. If the order is not consistent or some values are omitted, a more sophisteicated approach can be used.
You can also keep your original field unchanged and just define a calculation field with the above calculation, using it to display your regional names instead of physically changing the data in this field.
Perfect. Thanks a lot. :)