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 <p...@lcsql.com> To: How to use LiveCode <use-livecode@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 <bonnm...@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 <richmondmathew...@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@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@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@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@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
