Finding empty or non-empty fields
You can find fields that contain no data or some data.
To find empty or non-empty fields:
1.
Start a find request.
See Making a find request.
2.
Refer to the following table for examples of different ways to search for empty or non-empty fields.
 
To find fields that are
Enter this in the field
Not empty (i.e., fields that have data)
*
Empty
=
3.
When you’ve entered the find criteria that you want, click Perform Find in the status toolbar, or choose Requests menu > Perform Find.
Note  If any value is empty in a repeating field, then a search using “=” returns that field.
To enter data in empty fields:
1.
Create a find request that returns the empty field you want to replace.
2.
Enter a value in the empty field in one record in the found set.
3.
Choose Records menu  > Replace Field Contents.
4.
Click Replace.
The value you entered is placed in every record in the found set.
Was this topic helpful? Send feedback.