Best data import approach

stephen barncard stephenREVOLUTION2 at barncard.com
Sat Mar 30 14:10:33 CDT 2013


and if the first line contains the names of the individual fields on the
first row, you can

put the dgText[true]


On Sat, Mar 30, 2013 at 12:03 PM, Mike Bonner <bonnmike at gmail.com> wrote:

> 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
> >
> _______________________________________________
> 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
>



-- 



Stephen Barncard
San Francisco Ca. USA

more about sqb  <http://www.google.com/profiles/sbarncar>


More information about the use-livecode mailing list