Minggu, 01 Januari 2012

Re: [ExcelVBA] Surname to binary ?

 

*Emphasis:
* you could convert each letter to its letter number a=1 b=2 etc etc
convert that to binary and stuff in any spacer zeros so you could then grab
5 decrypt it to the letter, grab the next five etc etc

Or have I entirely lost the plot?

*By jove, I think you might have it!!
That might work. You have given me some ideas. What I am trying to do is
sort some names on more than three columns to include the birth date, and
death date. I thought if I could convert that to a binary number (or
decimal number), I could convert that to a really high base number format,
and then sort on that value. Then everyone would be sorted correctly, and I
get around the three column sort limitation. I hope I made sense.

**Thank you.

**Robert*
*Genealogy without documentation is mythology! Always SOURCE your work.*

* *
Or have I entirely lost the plot?

On Sun, Jan 1, 2012 at 4:51 PM, Dr John C Bullas <john.bullas@gmail.com>wrote:

> **
>
>
> had a think
>
> like for like: you need something that can be reversed once
> "encrypted", the only way you could convert a name to a true binary
> number and then decode it would be to have a massive lookup list of
> binary numbers (serial numbers fo each name) and associated names and
> a way of ensuring each encryption was unique for different names and
> the same for each time the same name was "encoded"....
>
> I think what you want is encryption if it is to be reversible and
> someone has probably written a cypher and de-cypher script to do
> this.....
>
> letter to chunk: As you have a base 26 alphabet, trying to "reduce"
> this to a base 2 format means you could generate a binary number for
> each letter from 1 to 26 (1 to 11010 or 10000 to 11010 if you fill in
> spaces to generate strings of 5 digit phrases ) , so consider the name
> smith would expand five fold, decrypting this would be easy so you
> need a cypher and a like for like letter transposition can be cracked
> based on number or letter frequency
>
> you could convert each letter to its letter number a=1 b=2 etc etc
> convert that to binary and stuff in any spacer zeros so you could then
> grab 5 decrypt it to the letter, grab the next five etc etc
>
> Or have I entirely lost the plot?
>
> Dr B
>
> On 1 January 2012 21:48, Robert E. Carneal
> <kentuckygenealogist@gmail.com> wrote:
> >
> > *Is it possible to take a person's name, and convert it to a binary
> number?
> > I can convert any number, any number system to a binary number, but can't
> > seem to figure out a way to convert names similar to:
> >
> > DoeJohnWilliam
> > EsrankKathyMaria
> > MooreJamesAndrew
> > ThomasRaymondDavid
> >
> > And so on. When I looked on The Internet, it kept wanting me to convert
> > names to Soundex codes
>

[Non-text portions of this message have been removed]

__._,_.___
Recent Activity:
----------------------------------
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

----------------------------------
MARKETPLACE

Stay on top of your group activity without leaving the page you're on - Get the Yahoo! Toolbar now.

.

__,_._,___

Tidak ada komentar:

Posting Komentar