Minggu, 01 Januari 2012

Re: [ExcelVBA] Surname to binary ?

 

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, but I need something that generates a more unique
> number than that, if possible.
> *
> *Thank you.
>
> **Robert*
> *Genealogy without documentation is mythology! Always SOURCE your work.*
>
>
> [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

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