Table field

[dunbarx at aol.com]

The colunDelimiter will not. in and of itself, extract, say, the third item of all the lines in a tab and return formatted dataSet. DataGrids have this sort of functionality built-in, but that is still constructed from standard LC techniques.
As per the above, if you wanted that third item all down the table, you have to loop through each line and dig it out, as others have already said.


Craig Newman



-----Original Message-----
From: Peter Haworth <pete at lcsql.com>
To: How to use LiveCode <use-livecode at lists.runrev.com>
Sent: Sat, Jul 11, 2015 6:36 pm
Subject: Re: Table field


What Mike said.  It's somewhat confusing since there is a
"columndelimiter"
property which is set to tab by default but it seems to only
be used in
conjunction with the split command.

On Sat, Jul 11, 2015 at 12:57
PM Mike Bonner <bonnmike at gmail.com> wrote:

> Its tab and cr delimited data,
so set the itemdelimiter to tab and get item
> 2 o fline 3 of field "xxx"
>
>
On Sat, Jul 11, 2015 at 1:51 PM, Richmond <richmondmathewson at gmail.com>
>
wrote:
>
> > I have a table field containing some data I copy pasted from a
>
spreadsheet
> >
> > [being unable to find a reliable way to import data
directly from a
> > spreadsheet]
> >
> > that runs across 3 columns.
> >
>
> When I tried this:
> >
> > put column 2 of line 3 of fld "XXX"
> >
> > I
had no joy.
> >
> > I would be grateful if someone could tell me how to
extract data from
> > individual cells in a table field.
> >
> > Richmond.
>
>
> > _______________________________________________
> > use-livecode mailing
list
> > use-livecode at lists.runrev.com
> > Please visit this url to subscribe,
unsubscribe and manage your
> > subscription preferences:
> >
http://lists.runrev.com/mailman/listinfo/use-livecode
> >
>
_______________________________________________
> use-livecode mailing list
>
use-livecode at lists.runrev.com
> Please visit this url to subscribe, unsubscribe
and manage your
> subscription preferences:
>
http://lists.runrev.com/mailman/listinfo/use-livecode
>
_______________________________________________
use-livecode
mailing list
use-livecode at lists.runrev.com
Please visit this url to subscribe,
unsubscribe and manage your subscription
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode