On 20/09/2016 21:16, Keith Clarke wrote:
Hi folks, I’ve a large number of sizeable CSV files from each of which I need to extract just 2 or 3 specific columns. Creating nested iterations through every item in every line seems somewhat inefficient - as does loading each full file into memory - so I feel I must be missing a trick here. Does Livecode support any elegant way of directly manipulating or ‘querying’ (like SQL) delimited data, to extract numbered (or named) columns/items - such as 1(Id), 3(Name) & 15(Summary) - from in each line from a CSV container or direct from a file/URL?
I would probably just use Mike Kerner's libraries: https://github.com/macMikey/csvToText Peter -- Dr Peter Brett <peter.br...@livecode.com> LiveCode Technical Project Manager lcb-mode for Emacs: https://github.com/peter-b/lcb-mode _______________________________________________ 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