putting data into a table
janschenkel at yahoo.com
Sun May 23 14:14:47 CDT 2004
--- Rich Lague <laguer at ucs.orst.edu> wrote:
> Can I just somehow paste a tab-delimited text file,
> (saved that way in
> Excel), into a table field? When I try this all the
> data goes into the
> first cell--there is no recognition of the tabs so
> that data is put
> into different cells on the same line. There is also
> no recognition of
> the returns so that new records are placed on the
> next line.
> Is there a manual way to paste the file? Is there a
> way to do this with
> a script?
> Rich Lague
If you've turned the field's vertical grid on, then
something like this should work fine :
answer file "Pick a tab-delimited text file"
if it is empty then exit mouseUp
put URL("file:" & it) into field "MyTable"
Or is this what you're doing and is it producing
unexpected results ?
"As we grow older, we grow both wiser and more foolish at the same time." (La Rochefoucauld)
Do you Yahoo!?
Yahoo! Domains Claim yours for only $14.70/year
More information about the use-livecode