• 100% Satisfaction Guarantee

Andy, Computer Consultant
Category: Computer
Satisfied Customers: 5316
Experience:  11yr exp, Comp Engg, Internet expert, Web developer, SEO
16465236
Andy is online now

# Needed Simple Algorithm to Reduce Length of Concatenated Numeric Val

### Customer Question

Here's the problem I need to solve:

I need to create a unique key in an Oracle DB from the following source data:

field 1: char(2) sample data: 67
field 2: char(6) sample data: 000019
field 3: char(6) sample data: 000182

Here are the constraints:

There may be duplicate values in any field, but the combination of
field1, field2 and field3 will always be unique.

The maximum key length must be 12 characters or less, and every
character in the key must be a numeric value [0123456789]

All positions in all 3 fields may contain data - I can't simply
truncate the first position of field2 and field3 and concatenate all 3
to arrive at a 12 character (or less)unique key.

The challenge seems to be generating the key from the source fields by
a numerical calculation that yields a value that is unique and cannot
be produced from the a different set of source fields.

Here is an example:

field 1: 12
field 2: 000019
field 3: 000182

Simple multiplication (12 x 19 x 182) yields 41496 - which fits the
length and numerical character constraints, but could be produced by
the same values in a different order: example: 12 x 182 x 19 also =
41496

I suspect their is an algorithm or other calculation (crypto?) that
will produce the key as desired. No code required in the answer, just
the calculation or a link to the calculation.

Thanks and good luck!

-Rick
Submitted: 11 years ago.
Category: Computer
Expert:  xarqi replied 11 years ago.
What you request is impossible.
Customer: replied 7 years ago.
Thanks anyhow

Ask-a-doc Web sites: If you've got a quick question, you can try to get an answer from sites that say they have various specialists on hand to give quick answers... Justanswer.com.
...leave nothing to chance.
Traffic on JustAnswer rose 14 percent...and had nearly 400,000 page views in 30 days...inquiries related to stress, high blood pressure, drinking and heart pain jumped 33 percent.
Tory Johnson, GMA Workplace Contributor, discusses work-from-home jobs, such as JustAnswer in which verified Experts answer people’s questions.
I will tell you that...the things you have to go through to be an Expert are quite rigorous.

### What Customers are Saying:

• My Expert answered my question promptly and he resolved the issue totally. This is a great service. I am so glad I found it I will definitely use the service again if needed. One Happy Customer New York
< Previous | Next >
• My Expert answered my question promptly and he resolved the issue totally. This is a great service. I am so glad I found it I will definitely use the service again if needed. One Happy Customer New York
• I am very happy with my very fast response. Eric is very knowledgeable in the subject area. Thank you! RP Austin, TX
• Hi John, Thank you for your expertise and, more important, for your kindness because they make me, almost, look forward to my next computer problem. After the next problem comes, I'll be delighted to correspond again with you. I'm told that I excel at programing. But system administration has never been one of my talents. So it's great to have an expert to rely on when the computer decides to stump me. God bless, Bill Bill M. Schenectady, New York
• The Expert answered my Mac question and was patient. He answered in a thorough and timely manner, keeping the response on a level that could understand. Thank you! Frank Canada
• Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help. Mary C. Freshfield, Liverpool, UK
• This expert is wonderful. They truly know what they are talking about, and they actually care about you. They really helped put my nerves at ease. Thank you so much!!!! Alex Los Angeles, CA
• Thank you for all your help. It is nice to know that this service is here for people like myself, who need answers fast and are not sure who to consult. GP Hesperia, CA

• ### Andy

#### Satisfied Customers:

5316
11yr exp, Comp Engg, Internet expert, Web developer, SEO
< Last | Next >

### Andy

#### Satisfied Customers:

5316
11yr exp, Comp Engg, Internet expert, Web developer, SEO

### Engineer John C.

#### Satisfied Customers:

3220
Computer Science Engineer with 10 years of experience in Computer Support, and Microsoft, A+ and Cisco certified

### Ryan H.

#### Satisfied Customers:

1741
A+ Certified Technician - 10 Years experience working with all types of computer systems.

### Jane Lefler

#### Satisfied Customers:

0
Computer Programmer / Technician/ Consultant 16+ years

### Frederick S.

#### Satisfied Customers:

7241
Computer technician and founder of a home PC repair company.

### lifesaver

#### Satisfied Customers:

4288
Engineering degree in Computer science,Microsoft Certified Professional.JA computer expert.

### James K.

#### Satisfied Customers:

4103
Technical Director of IT Company