![]() |
Convert WordPerfect Table To Lotus, dBASE Rea |
The information in this document applies to:
WordPerfect® 5.1 for DOS
Problem
Solutions: NOTE: This information only applies to an existing table that does not have ANY HRts inside the table. If you want to keep all of the information in the proper cell, you need to first delete ALL HRts in the table and then proceed with the following instructions. If the HRts are not taken out, then the text that was separated by the HRt will be in different fields. After the text is imported to the desired program, then put the HRts back where you need them. The following steps were developed to convert a WordPerfect table to a format that Lotus 1-2-3 versions 1 through 2.2 can use: Note: These steps are only to be used if CONVERT.EXE is the conversion utility in use. ConvertPerfect will convert tables to SDIF format without problems. 1. Place the table to be converted in a separate document. (Block from the Table Definition code to the Table Off code, then press F10 and type in a filename). 2. Retrieve the saved table on the screen and press the Home key three times and then the Up Arrow key. Delete the Table Definition Code and the first [HRt] before the text. 3. Replace all of the Hard Returns with [End Field][HRt][End Record][HPg] as follows: a. Press Alt-F2, N for No on Confirm, press the Enter key for the [HRt] code, press F2, then F9 for the [End Field] code. b. Press the Enter key for the [HRt] code, Shift-F9, 2 for the [End Record] code. c. Press Ctrl-Enter for the [HPg] code. d. Press F2 to perform the Replace. 4. Replace the Tab codes with End Field codes as follows: a. Press the Home key three times and then the Up Arrow. b. Press Replace (Alt-F2), N for No on Confirm, the Tab key for the [TAB] code, Search (F2), F9 for the [End Field] code, and then Enter for the [HRt] code. Now press F2 to perform the Replace. 5. Now that the secondary merge file has been created, save the document (F10). 6. Exit out of WordPerfect. 7. Change to the WordPerfect directory by typing CD\WP51 and pressing Enter. 8. Start the document convert by typing CONVERT at the DOS prompt and press Enter. Now enter the filename to convert including the path (i.e., C:\WP51\TEST1) and the complete output filename. (The user may want to include the .DIF extension with the filename for easier conversion process in Lotus.) 9. Select 1 from the menu for WordPerfect to another format. 10. Select number 8 for Wordperfect secondary merge to Spreadsheet DIF. 11. Check to make sure that the database structure is created and ready to receive data. Depending on the database program, the matter of importing will be different. For dBASE IV the command at the DOT prompt inside dBASE will be APPEND FROM [filename.dif] TYPE DIF This command will import the information to the database. Also make sure that the field widths are wide enough to accept the data or the data that will not fit may be lost. See also memo WP51_5946M for more information on export of documents readable by Lotus. One customer used step 4 in the following manner to change a table into a secondary merge file: 1. Delete the Table Definition code 2. Search for [HRt] and replace it with [End Record][HPg] 3. Search for [Tab] and replace it with [End Field][HRt] |
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. |