why not concatenate the text column in the same was as suggested based
on sorting order, spacing to the right of the text strings up to
MAX(Length()) with spaces" "???
JB
On 2 January 2012 03:44, Robert E. Carneal
<kentuckygenealogist@gmail.com> wrote:
> *Sorting. If I were going to sort only on three columns, that would be
> easy. A lot of my ancestors have the same name, so I thought I would
> digitize the name somehow, and convert to a higher base number, say base
> 64. For this to work, each number needs to be convertable back to the
> original name. That is the problem I am having. Sometimes a number can
> convert back to two, or three names.
>
> Before you suggest it, yes, I do have a genealogy program, it will not do
> what I am trying to do unfortunately. I thought perhaps I could convert a
> name like BrownJamesWilliam to *unique* digits (so I can reconvert back to
> the name later), and then convert that to a higher based number, and maybe,
> just maybe, I can end up with a six character code to sort on.
>
> **Thank you.
>
> **Robert*
> *Genealogy without documentation is mythology! Always SOURCE your work.*
>
>
> On Sun, Jan 1, 2012 at 9:34 PM, David Braithwaite
> <dbraithwaite@charter.net>wrote:
>
>> **
>>
>>
>> Robert
>>
>> Have you said how you are going to use the binary number associated with a
>> name (or word, or phrase, or string of characters) ?
>>
>> It will have a bearing on the solution.
>>
>> db
>>
>
>
> [Non-text portions of this message have been removed]
>
>
>
> ------------------------------------
>
> ----------------------------------
> Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.
>
> ----------------------------------
> Visit our ExcelVBA group home page for more info and support files:
> http://groups.yahoo.com/group/ExcelVBA
>
> ----------------------------------
> More free tutorials and resources available at:
> http://www.mousetrax.com
>
> ----------------------------------Yahoo! Groups Links
>
>
>
--
===========================
http://uk.linkedin.com/in/drjohnbullas
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.
----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA
----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com
----------------------------------
Tidak ada komentar:
Posting Komentar