Jove
Visualize
Contact Us
JoVE
x logofacebook logolinkedin logoyoutube logo
ABOUT JoVE
OverviewLeadershipBlogJoVE Help Center
AUTHORS
Publishing ProcessEditorial BoardScope & PoliciesPeer ReviewFAQSubmit
LIBRARIANS
TestimonialsSubscriptionsAccessResourcesLibrary Advisory BoardFAQ
RESEARCH
JoVE JournalMethods CollectionsJoVE Encyclopedia of ExperimentsArchive
EDUCATION
JoVE CoreJoVE BusinessJoVE Science EducationJoVE Lab ManualFaculty Resource CenterFaculty Site
Terms & Conditions of Use
Privacy Policy
Policies

Related Experiment Videos

Translating mainframe computer data to spreadsheet format.

T G Burnakis1

  • 1Department of Pharmacy, Wyandotte Hospital and Medical Center, MI 48192.

American Journal of Hospital Pharmacy
|December 1, 1991
PubMed
Summary
This summary is machine-generated.

Related Concept Videos

You might also read

Related Articles

Articles linked to this work by shared authors, journal, and citation graph.

Sort by
Same author

Cardiovascular events and COX-2 inhibitors.

JAMA·2001
Same author

Therapeutic interchange of low-molecular-weight heparins.

American journal of health-system pharmacy : AJHP : official journal of the American Society of Health-System Pharmacists·2000
Same author

Antibiotic prophylaxis in cataract operations.

Mayo Clinic proceedings·1997
Same author

Interferon alfa in the treatment of chronic viral hepatitis B and C.

The Annals of pharmacotherapy·1997
Same author

Alternatives to oral antihypertensive agents.

American journal of health-system pharmacy : AJHP : official journal of the American Society of Health-System Pharmacists·1995
Same author

Another perspective on monitoring anticoagulation therapy.

The Annals of pharmacotherapy·1995
Same journal

National health care reform, Part 2: Response to pharmacists.

American journal of hospital pharmacy·1994
Same journal

Validity of originality assessment.

American journal of hospital pharmacy·1994
Same journal

Unit dose dispensing of chromic phosphate P 32 suspension.

American journal of hospital pharmacy·1994
Same journal

Hydralazine injection still available.

American journal of hospital pharmacy·1994
Same journal

Improved extemporaneous formulation of cyclosporine ophthalmic drops.

American journal of hospital pharmacy·1994
Same journal

Paclitaxel diluent and the case of the slippery spike.

American journal of hospital pharmacy·1994
See all related articles

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.

Related Experiment Videos

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.