Top Navigational Bar

How To Sort A Blank Field - Use Select And So
DocumentID: 608643
Revision Date: 29-Feb-96 1:33:25 PM

The information in this document applies to:
WordPerfect® 5.1 for DOS

Problem

Solutions: A customer was trying to use the Sort feature to select all the records in a secondary merge file that had Field 5 blank. In order to do this the customer must first define the keys they want to use, then when selecting text, they can continue with the selection process by choosing Action, Select, and typing in key1= (leaving the rest blank because the field they are looking for is blank). This will work for an alphanumeric sort and looks as follows:

Set Key 1 to read: Type Field Line Word
a 1 1 1

Set Select to read: key1=

If the Sort is numeric, a user can select records with blank fields using key1< in the Select field in the Sort menu. For example, to select the records that have the first field blank, set up the sort menu like the following:

Set Key 1 to read: Type Field Line Word
n 1 1 1

Set Select to read: key1<

A customer can use the asterisk, * (or) and plus, + (and) operators in conjunction with these select statements. For example:

Set Key 1 to read: Type Field Line Word
a 1 1 1

Set Key 2 to read: Type Field Line Word
a 2 1 1

Set Select to read: key1= + key2=

This select statement would select records that have a blank field one or two.

Answer:

Details:


Product specifications, packaging, technical support and information (*Specifications*) refer to theUnited States retail English version only. Specifications for other versions may vary. All Specifications, claims, features, representations, and/or comparisons provided are correct to the best of our knowledge of the date of publication, but are subject to change without notice.OUR MAXIMUM AGGREGATE LIABILITY TO YOU AND THAT OF OUR DEALERS AND SUPPLIERS IS LIMITED. IT SHALL NOTEXCEED THE AMOUNT YOU PAID TO ACCESS THE INFORMATION. SEE LEGAL DISCLAIMER.