Top Navigational Bar

Numeric Paragraph Sorting - Sort With Decimal
DocumentID: 612292
Revision Date: 29-Feb-96 1:35:27 PM

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

Problem

Symptoms: When sorting using a numeric paragraph sort in ascending order, the majority of the sort is fine; however, randomly the sort order is incorrect. Sorting alphanumerically solves the problem, but the user has other entries in the document that have a different number of digits that the sample does not represent. It should, therefore, be necessary to sort numerically. Solutions: Development states that when performing a numeric sort, the program checks the first 12 characters before the decimal point and then the four characters after the decimal point. Therefore, the customer's file will sort randomly.

Problem:
When performing a table sort with numbers containing two decimal points (i.e., 02.080.040), the numbers are not sorted correctly.

Answer:
This situation occurs because the decimal align character is defined as a period. If the user changes the decimal align character to something other than a period, the problem does not occur. When doing a numeric sort, the first period is being treated as a decimal align character, so there is only "one word" with two characters before the decimal and the six characters after the decimal. WordPerfect only recognizes four characters after the decimal point, so the numbers are sorted randomly.

It is possible to perform a sort on decimal numbers (e.g., 08.090.090) in a table. This sort can be done by considering the decimal to be a word separator. Because the second decimal is ignored, the third number will not sort unless the first decimal is removed.

Another customer was trying to sort a list of numbers like the following:
      7.0102.3.7
      8.2920.3.9
When the user sorted the list, it would ignore the last two decimals. The customer changed the keys in Sort to alphanumeric (instead of numeric) because all of the numbers were the same length. After making this change, the list sorted correctly.

Status:      Working as Designed
***|wad|***
Press Enter on link token to view statement.

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.