(no subject)

Jan Schenkel janschenkel at yahoo.com
Thu Sep 19 04:11:01 EDT 2002

Hi Jerry,

If you have the table entered in Excel or AppleWorks
or another spreadsheet, you could always export the
data using "Save as" in "Text (tab-delimited)" format.
Then you can simply
  put URL "file:<path-to-the-file>" into theData

Now you'll have everything read in a single variable,
where the rows are separated by return and the columns
by tab ; which you can easily display in a field
  put theData into field "tableField" 

If you setup that field with tabStops, and show both
the horizontal and vertical grid, you can get a nice
look for displaying the data.

It's also very easy to convert that variable (where
everything is still on several lines) into an array.
  split theData using return and tab

Now you can address any "cell" or "intersection" with
  put theData[<income>,<children>]

Hope this helped,

Jan Schenkel.

"As we grow older, we grow both wiser and more foolish
at the same time."  (De Rochefoucald)

--- Jerry Thomas <runrev at hotmail.com> wrote:
> [snip]
> I have to enter the data in the 
> table by hand. The data are used in a simple
> arithmetic formula to calculate 
> the rest of the numbers in my project. The user will
> see the intersection 
> data that has been brought forth by this "lookup"
> table and it will be 
> printed in a form. They will not see the table it
> came from .  This is a 
> database or an array, albeit a very simple one and I
> need to know how to 
> program it in revolution. Thanks for your help
> though.
> MSN Photos is the easiest way to share and print
> your photos: 
> http://photos.msn.com/support/worldwide.aspx
> _______________________________________________
> use-revolution mailing list
> use-revolution at lists.runrev.com

Do you Yahoo!?
New DSL Internet Access from SBC & Yahoo!

More information about the Use-livecode mailing list