Seeking a navigation system among 200 individual / card DB for attendance at camp
Kay C Lan
lan.kc.macmail at gmail.com
Wed Jun 13 19:33:00 CDT 2012
What Bob said but his caveat is easily handled.
I suggest when you create your list of data your DO NOT use comma or tab as
the itemDelimiter. I tend to use | or numToChar(127) - which is invisible.
If your data is going to contain remarks, or notes, as yours clearly is,
then it will contain commas and tabs so this creates all sorts of hassles.
Go with a character that is NEVER going to appear naturally in your data.
Once you do that, instead of:
sort index1 by last word of each
sort index1 by item 2 of each
assuming of course that item 1 contains one or more given names, and item 2
contains any combination of words and punctuation that makes up a Surname.
PS Never really understood why RunRev went with comma as an itemDelimiter
when it appears so commonly in data that you are forever having to change
the itemDelimiter to something less troublesome. Why not just go with ^ or
| or ` or ~.
Cue Richard and his link to his request never to create a CSV exporter, oh
what the heck, I'll provide the link myself ;-)
CSV Must Die
More information about the use-livecode