![]() |
Tables - Export Into A Format Readable By Lot |
The information in this document applies to:
WordPerfect® 5.1 for DOS
Problem
Solutions: NOTE: This information applies only to an existing table that does not contain ANY Hard Return [HRt] codes. If you want to keep the information in the proper cells, you must first delete ALL [HRt] codes from the table and then proceed with the following instructions. If you do not remove the [HRt] codes, then the text that is separated by the [HRt] codes will be in different fields. After you import the text into the desired program, place the [HRt] codes back where you need them. The following steps will convert a WordPerfect 5.1 table into a format readable by Lotus 1-2-3 (versions 1 through 2.2): 1. Place the table to be converted in a separate document. This can be done with Block and Copy or Block and Save. 2. With the table on the screen, press Home three times, followed by the Up Arrow. Delete the Table Definition [Tbl Def:] code and the first [HRt] code before the text. 3. Replace all of the [HRt] codes with the following codes: {End Field}[HRt]{End Record}[HPg] This can be done with Search and Replace (Alt-F2, N [HRt], F2, F9-{End Field}, [HRt], Shift-F9, 2-{End Record}, [HPg] code, F2). 4. Replace the Tab [TAB] codes with End Field {End Field} codes. This can also be done with Search and Replace (Alt-F2, N, [TAB], F2, F9-{End Field}, [HRt], F2). 5. Save the file and exit WP. 6. Change to the WordPerfect directory (CD\WP51). Convert the file using the Convert program. When prompted for the output filename, type the desired name with a .DIF extension. Select option 1-WordPerfect To Another Format, then option 8-WordPerfect Secondary Merge To Spreadsheet DIF. 7. Change to the Lotus directory (CD\123). Start Lotus (Lotus) and select option T-Translate from the Access menu. When prompted for the format, select DIF. Next, select the version of Lotus to convert to (e.g., Lotus 2, 2.01, 2.2). 8. Lotus will then list some hints on how to convert the DIF file properly. To exit this screen, press Escape. Lotus will then list all of the files in the current directory that have a .DIF extension. Select the file to be converted, and press Enter twice. To preserve the original layout, select the Columnwise option, and answer Y to proceed with the translation. 9. Press Escape twice, and answer Y to leave Translate. The cursor will return to the Access screen. 10. Press 1 to enter Lotus and retrieve the new file. |
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. |