Sorting compound names

[Ruslan Zasukhin]

On 9/18/04 10:14 PM, "jda" <jda at his.com> wrote:

>> What about this:
>> 
>> You make 2 fields:
>> 
>>     prefix
>>     LastName
>> 
>> 
>> If syrname is
>> 
>>     von Something
>> 
>> You split it in 2 fields.
>> If there is no name then prefix is empty.
>> 
>> So when you show to user you build string using 2 fields.
>> 
>> And you use the second filed to sort.
>> 
>> In case exists also suffixes, then you create third field.
>> 
> 
> Hm, interesting. But in my case the names are not in individual
> fields, but listed in one field (separated by returns).
> 
> What about this -- can this be done in 2.x?
> 
> 1. Get a cursor.
> 2. Find/replace every occurrence of a "forbidden" word (list provided
> by the user) in the name field (e.g. find "von " and replace with "").
> 3. Sort the cursor by that field...
> 
> Or is this something that can/should be done with temporary tables?

Only tmp table

I still believe that if you have some data that must be proceed in separate
way, you must extract them into separate column

-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------