Best data import approach
pete at lcsql.com
Sat Mar 30 19:06:10 CDT 2013
Datagrids assign a unique dgIndex which stays constant for each line after
they're sorted but I don't recall any automated way to sort by it. Maybe
you could just add a column to the input after you read it from your file
with an incrementing number in it so it would end up as a column in the
datagrid (hidden if you prefer it that way).
lcSQL Software <http://www.lcsql.com>
On Sat, Mar 30, 2013 at 3:52 PM, Magicgate Software - Skip Kimpel <
skip at magicgate.com> wrote:
> Back to my sorting issue with date and time, quite honestly, the log file
> is already sorted.... I just need to have the DataGrid display it as it was
> read into the system with out trying to do additional sorting. Is there a
> way to sort, for instance, by some itemID number that the DataGrid assigns
> to it?
> On Sat, Mar 30, 2013 at 5:51 PM, Magicgate Software - Skip Kimpel <
> skip at magicgate.com> wrote:
> > Thank you! ....
> > http://www.fourthworld.com/embassy/articles/csv-must-die.html
> > On Sat, Mar 30, 2013 at 5:42 PM, Alex Tweedly <alex at tweedly.net> wrote:
> >> Of course. You can find it best in Richard's excellent article about the
> >> evils of CSV format, at
> >> http://www.fourthworld.com/**embassy/articles//csv/-/must/-**/die/.html
> >> It does deal with many of the vagaries, but won't do anything about
> >> records with different number of fields (I think that was what you
> >> mentioned earlier in the email thread), though it will (AFAIR) deal with
> >> embedded CRs if they are within a quoted string.
> >> BTW - there is the opportunity for a slightly faster method which avoids
> >> the array step - but the difference would only be significant for VERY
> >> large data sets, so I've not had the incentive to finalize and test it
> >> thoroughly.
> >> -- Alex.
> >> On 30/03/2013 20:51, Magicgate Software - Skip Kimpel wrote:
> >>> Excellent... Thank you Pete...
> >>> Alex, would you be so kind to share?
> >>> 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:
More information about the use-livecode