Related Experiment Videos
Translating mainframe computer data to spreadsheet format.
1Department of Pharmacy, Wyandotte Hospital and Medical Center, MI 48192.
American Journal of Hospital Pharmacy
|December 1, 1991
Summary
Learn how to translate mainframe data into Lotus 1-2-3 spreadsheets using ASCII files and the Data Parse command. This process simplifies data handling and avoids manual rekeying of crucial information.
Area of Science:
- Computer Science
- Data Management
Background:
- Mainframe systems store vast amounts of data.
- Manual data transfer to spreadsheets is time-consuming and error-prone.
- Spreadsheet software like Lotus 1-2-3 is essential for data analysis.
Purpose of the Study:
- To explain the process of translating mainframe data into Lotus 1-2-3 spreadsheet format.
- To detail the use of the Data Parse command for ASCII file translation.
- To highlight the efficiency of direct data format translation.
Main Methods:
- Utilizing the Data Parse command within Lotus 1-2-3.
- Creating translation templates to interpret ASCII files.
- Leveraging Lotus 1-2-3's native ability to translate Data Interchange Format files.
Main Results:
- Successful translation of mainframe data stored in ASCII to Lotus 1-2-3 spreadsheets.
- Demonstration of how to create effective translation templates.
- Confirmation that Lotus 1-2-3 can directly import Data Interchange Format files.
Conclusions:
- Translating mainframe computer data into spreadsheet format is straightforward.
- The described methods eliminate the need for manual data rekeying.
- This facilitates more efficient use of mainframe data in spreadsheet applications.