AnsweredAssumed Answered

Updating records

Question asked by PhilLanzisera on Aug 20, 2009
Latest reply on Aug 20, 2009 by PhilLanzisera


Updating records


I have data from surveymonkey. If someone selected an option, a number appears in that field. If the person didn't select that option, the field is blank. Unfortunately what surveymonkey puts in the field is not all that useful. So, I want to change it. I was going to do a find/replace. I have to select a field. I highlighted the target field in browse mode, but that didn't do it. I was able to create a new field that is calculated on the basis of a test for the field value not being "". I tried a script that loops through the file testing if the field has a value or is blank. Unfortunately no matter how I write the test, every record is changed to the "else" portion of the test. So, I am lost. Any ideas?