Article View: comp.sys.next.software
Article #822Re: Mesa --- lack of database functionality
From: Ivo Welch
Date: Thu, 20 Aug 1992 17:12
Date: Thu, 20 Aug 1992 17:12
32 lines
2204 bytes
2204 bytes
Here is why I need a swiss-army-knife spreadsheet (actually most spreadsheets already have some appropriate database functions, such as sorting [although merging is a problem]): I have a lot of academic (often hand-collected) databases where I have to hand-change and hand-check values all the time. Believe it or not: I often stoop to using Emacs to store this data. With a spreadsheet, I could highlight/boldface questionable data, browse through it, and put comments into column B for the values in column A. If I want to extract values, I simply put zmesa s.mesa | cut -f1 | <other functionality handling data> Spreadsheets are still the easiest on-the-fly databases for 1-10MB databases. Statistical packages should have a lot of this functionality, but unfortunately they do not. As to alternatives, dataphile is too multi-media+report rather than alpha-numerically+storage oriented, and more expensive (factor 6). SAS is even more expensive and much less user-friendly. Finally, although there are non-trivial implementation issues to consider for how to save tabular text, my requested feature is trivial to add, because I want exactly the same output as that produced by a "SAVE TO ASCII/Export-to-tabular-text" command, a part of EVERY spreadsheet package, including Mesa. I bet Athena Design could repackage the relevant code into a stand-alone program in one hour. If you agree, here is Athena's e-mail address: feedback@athena.com /ivo PS: Also, with a command-line interface, I could invent new uses, such as the ability to read spreadsheets into GNU Emacs.
Technical Details
Message-ID:
<1992Aug20.101238.20758@mic.ucla.edu>Path:
arc1-ca.pugleaf.net!sparky!uunet!dtix!darwin.sura.net!mips!bridge2!news.claremont.edu!ucivax!ucla-cs!ucla-mic!agsm!iwelchReferences:
<1992Aug19.143528.9405@mic.ucla.edu> <BtA46G.Bzp@monitor.com>Show Full Headers
Complete Article Headers
Path: arc1-ca.pugleaf.net!sparky!uunet!dtix!darwin.sura.net!mips!bridge2!news.claremont.edu!ucivax!ucla-cs!ucla-mic!agsm!iwelch From: iwelch@agsm.ucla.edu (Ivo Welch) Newsgroups: comp.sys.next.software Subject: Re: Mesa --- lack of database functionality Message-ID: <1992Aug20.101238.20758@mic.ucla.edu> Date: 20 Aug 92 17:12:38 GMT References: <1992Aug19.143528.9405@mic.ucla.edu> <BtA46G.Bzp@monitor.com> Organization: UCLA, Anderson Graduate School Of Management Lines: 32 Nntp-Posting-Host: risc.agsm.ucla.edu