Seeking a navigation system among 200 individual / card DB for attendance at camp

Kay C Lan lan.kc.macmail at
Wed Jun 13 20:33:00 EDT 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

you do:

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 mailing list