Top Navigational Bar

Sorting Information Across Tabular Columns
DocumentID: 613604
Revision Date: 29-Feb-96 1:35:47 PM

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

Problem

Solutions: FYI:
A customer had information in tabular columns that needed to be sorted in alphabetical order across the columns. The document was set up as follows:

CAR[TAB]CAT[TAB]COAT[HRt]
ANTEATER[TAB]ASEOP[TAB]AWAY[HRt]
BATTER[TAB]BETTY[TAB]BOOP[HRt]

Sort will not sort across columns. To work around this limitation, the customer created a macro that did the following:

1.      Using Search and Replace, the macro replaced all Tab codes with Hard Return [HRt] codes so that all the words were on their own line at the left margin.
2.      The sort was then performed so the words were in order, going down.
3.      Search and Replace was used again to replace all the Hard Return [HRt] codes with an asterisk (*) or any character not in the document already.
4.      At the beginning of the document, parallel columns were defined and turned on. At this point, all the text should be in the left column ONLY.
5.      Then the macro searched for the asterisk (*), backspaced it out, and replaced it with a Hard Page Break [HPg] code. Note: This portion of the macro would have to loop several times in order to replace all the asterisks with [HPg] codes because Search and Replace alone will not accomplish this task.
6.      When the macro had completed, the information looked as follows:

      ANTEATER ASEOP AWAY
      BATTER BETTY BOOP
      CAR CAT COAT

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.