![]() |
Convert Lotus To WordPerfect Secondary File |
The information in this document applies to:
WordPerfect® 5.1 for DOS
Problem
Symptoms: When Lotus 123 files are translated to DIF using the Lotus Translate Utility, the numbers in the files come across in scientific notation. Solutions: Using the process listed below will bring numbers across as decimals. This eliminates having to go in and change all of the numbers. 1. Load Lotus and retrieve the desired file (123, /, File, Retrieve, Filename). 2. Modify the file to eliminate titles, etc. It is best to only include the data. The cosmetics can be added in your WordPerfect Primary document. 3. Print the spreadsheet to disk (/, Print, File, Range, Go). Save your document and exit Lotus. This operation creates a .PRN file. 4. In a blank Lotus worksheet, use /, File, Import, Text to bring up the .PRN file (123, /, File, Import, Filename.PRN, Text). /File Import transfers a file from another program to 1-2-3 and converts it to 1-2-3 format. Lotus treats data imported with /File Import Text as long labels of text. /File Import Text puts these labels in the column where your cell pointer was located when you executed the command. There are only cell entries in that single column, even though the data may look like it contains columns of text or numbers. 5. Use the /Data, Parse operation to separate the text into fields. Format all fields as Labels in this procedure. (/, Data, Parse, Format-Line, Create). (Format-Line, Edit) if any block is not wide enough to accommodate any of the data that will be parsed in the rows beneath it, Edit the Format-Line. 6. Select Input-Columns and enter the range containing the column of format lines and cells you want to parse. 7. Select Output-Range and enter the cell address where you want the highlighted information to be copied to. Be sure the output range is blank. Select Go. Lotus produces a parsed copy of the imported data in the output range. Save the file with a new name. 8. Exit Lotus and execute the Translate Utility from the DOS prompt (TRANS). Translate the new file from Lotus to a .DIF format. Exit to DOS. 9. Using CONVERT.EXE, convert the new DIF file to a Spreadsheet Secondary Merge file. 10. Go into WordPerfect and retrieve the new secondary merge file. The filed data will be in the desired text format and not in scientific format. Another option to use a Lotus file as a secondary merge file is as follows: 1. Import the 123 spreadsheet directly into WP (Shift-F10). 2. Turn on Reveal Codes. 3. Delete the Table Code. 4. Replace the Hard Returns with End Field, Hard Return, End Record, Hard Page. 5. Replace the Tabs with End Field and Hard Return. 6. Save the document. 7. Merge the Primary Document with the new Secondary 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. |