Roger Sage CDL / MELVYL SSH Library Home
SSHL Home Data, Gov't & GIS Home
FAQ   Downloading Tips   Processing and Quality Control 
Data Migration Project Home

File Processing and Quality Control

Title: State energy data system [electronic resource] : (SEDS)

Original diskette files: All diskettes were mounted on a 5 1/4" drive of a Windows 98 PC and the diskette files were copied to the PC hard drive. To preserve the original file content, all files were transferred to a UNIX server in binary format and retain their original time and date stamps.

Processed documentation file: The original DOS ASCII documentation file was examined with Perl "cio" (check-it-out) to identify extraneous control and high ASCII characters. Form feeds (octal 14) and the substitute control code (octal 32) were replaced with a blank using Perl "fix". DOS carriage returns (octal 15) were removed with UNIX "tr". The "fixed" file was saved with a .TXT file extension.

Processed data files: The original DOS ASCII CSV data files were examined with Perl "cio"(check-it-out) to identify extraneous control and high ASCII characters. The substitute control code (octal 32) was replaced with a blank using Perl "fix". DOS carriage returns (octal 15) were removed with UNIX "tr". The "fixed" files were saved with .CSV data file extensions.

You can view the 1992 "cio" output for the original ASCII diskette files.

Processed data tables: The Lotus data tables cannot be converted because they contain embedded Lotus macros that cannot be used by other spreadsheet software.


 

ROGER | Sage | CDL/MELVYL | UCSD Home | UCSD Libraries Home

Official Web Page of the University of California, San Diego
© Copyright 2000, UCSD, All Rights Reserved. This site may not be reproduced.
Social Sciences & Humanities Library, 9500 Gilman Drive, La Jolla, CA 92093, 858-534-3336
Email SSDC Webmaster