Best data import approach

Mike Bonner bonnmike at gmail.com
Sat Mar 30 15:03:38 EDT 2013


set the dgtext of group "yourgroup" to URL ("binfile:/path/to/the/file")
should work.  dgtext works directly with tab and cr delimited text, so
should be easy peasy.


On Sat, Mar 30, 2013 at 12:04 PM, Keith Clarke <
keith.clarke at clarkeandclarke.co.uk> wrote:

> Why not just put the file into a variable, set the item delimiters to tab
> and away you go?
>
> Just query the items of the first line to understand your (changing)
> column labels?
> Best,
> Keith..
>
> On 30 Mar 2013, at 17:54, Magicgate Software - Skip Kimpel <
> skip at magicgate.com> wrote:
>
> > Hello LC's,
> >
> > I have a tab delimited text file(log file) that I need to manipulate
> every
> > once in a while and extract data from it.  Is there a good way to read
> this
> > directly into a datagrid and manipulate it from there or I am better off
> > reading the file, loading it into a sqlite db and THEN manipulate it from
> > there.
> >
> > The text file I am reading is constantly changing so I can not just do a
> > one time conversion, I will always have to read from this file.
> >
> > This is for a desktop app, by the way....
> >
> > Thanks in advance for your input!
> >
> > SKIP
> > _______________________________________________
> > 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
>



More information about the use-livecode mailing list