How to extract specific columns/line items from a CSV file?

[Keith Clarke]

Thanks Richard - the target CSVs are indeed in the 1-100MB range (containing mostly noise data for my current purpose) and it’s always useful to know, amongst the many roads available with LiveCode, which 'all lead to Rome', with the same ETA! :-)
Best,
Keith..

> On 20 Sep 2016, at 22:42, Richard Gaskin <ambassador at fourthworld.com> wrote:
> 
> Keith Clarke wrote:
> 
> > It’s interesting that the url container can be addressed directly,
> > instead of loading the file
> 
>  get url ("file:"& tFile)
> 
> ...does the same as:
> 
>  open file tFile for read
>  read from file until EOF
>  close file tFile
> 
> It's just more convenient than using the three-line method (which can be very useful if you need for fine-grained control over the read, such as reading in chunks or from a particular offset).
> 
> Unless your files are much bigger than 100 MBs you should find loading them into memory well worth the effort for the time saved parsing them thee.
> 
> -- 
> Richard Gaskin
> Fourth World Systems
> Software Design and Development for the Desktop, Mobile, and the Web
> ____________________________________________________________________
> Ambassador at FourthWorld.com                http://www.FourthWorld.com
> 
> _______________________________________________
> 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