Richard,
Have you looked at Pseudotable Plus, available at the CrossWorlds site? It
has a script for converting data into the spreadsheet table, and others for
adding and deleting columns from the table; some combination of these might
give you what you need.
--Marni
On Thu, 08 Jun 2000 20:29:59 -0700, [EMAIL PROTECTED] wrote:
> I have a sticky problem, and maybe one of you has a cool solution:
>
> One of the apps I'm working on presents lists of tabular data, which may
> have as many as a couple thousand rows and potentially dozens of columns.
>
> I need to be able to display these quickly, as well as sort them, and to
> extract a subset of rows for display.
>
> I've tried multiple fields, which gives us the best look (very
> spreadsheet-like), but even with MC's much-improved field manipulation
doing
> the ol' "put item j of line i into line i of fld j" takes far too long on
> large data sets (using "repeat with..." helps, but not enough).
>
> And of course, using MC's built-in tabs doesn't work well for this, since
> adjusting the tabs can push adjacent columns off in a line where the
sgtring
> length exceeds the tabstop for that column.
>
> The ideal solution would be to have a true multi-column list object, but
> we'll have to wait for that. In the meantime, it occurs to be that there
> may be another way around this:
>
> Is there a quick way to break a large set of tabular data into columns?
>
> It's really easy to get all the columns of a particular row ("get line
> 200"), but is there some way to effectively turn this on it's side, to
> effectively say something like "get column 3"?
>
> If I could quickly break the data into columns for display, then I only
have
> one "put" for each field, which would be satisfyingly quick. And I
could
> still sort rows in the master set, spliting them into columns each time I
> need to display. Sweet.
>
> Any suggestions?
>
> --
> Richard Gaskin
> Fourth World
> Multimedia Design and Development for Mac, Windows, UNIX, and the Web
> _____________________________________________________________________
> [EMAIL PROTECTED] http://www.FourthWorld.com
> Tel: 323-225-3717 ICQ#60248349 Fax: 323-225-0716
>
>
> Archives: http://www.mail-archive.com/metacard%40lists.best.com/
> Info: http://www.xworlds.com/metacard/mailinglist.htm
> Please send bug reports to <[EMAIL PROTECTED]>, not this list.
>
_______________________________________________________
Get 100% FREE Internet Access powered by Excite
Visit http://freelane.excite.com/freeisp
Archives: http://www.mail-archive.com/metacard%40lists.best.com/
Info: http://www.xworlds.com/metacard/mailinglist.htm
Please send bug reports to <[EMAIL PROTECTED]>, not this list.