Generate unique code

Question

3.00/5 (2 votes)

See more:

Hi All,

I have table in which i store division_code and division_name.
For each division code should be unique.
division code is auto generated and it starts from "EM_" + 1st letter of division.

Ex: Division Name: Test -> Division Code:EM_T
Ex: Division Name: Test1 -> Division Code:EM_Te
Ex: Division Name: Terminate -> Division Code:EM_Ter

How to generate unique code if some division starts with same letters?

Posted 12-Aug-13 20:13pm

Sweetynewb

Add a Solution

Comments

Sergey Alexandrovich Kryukov 13-Aug-13 2:19am

First of all: what is 1) purpose of it, 2) the scope of uniqueness?
—SA

Sweetynewb 13-Aug-13 2:50am

Purpose- Requirement of system. i have to generate it..
Scope- if first letter is same then take first two letters of division name.

Sergey Alexandrovich Kryukov 13-Aug-13 2:53am

This is not purpose. Why such requirements? Some rational.
This is not really the scope. Do you understand this notion? Scope could be some application or a single runtime of it (it means that on second run the IDs are allowed to repeat, and this is a very usual case), local computers, some set of computers on a network, whole world, etc.

You are not answering critical questions. Your solution depends on them.

—SA

Sweetynewb 13-Aug-13 2:56am

Limitation is up to 3 letters.
But further what? that is what i am asking

I am doing this by doing substring of division name.

Sergey Alexandrovich Kryukov 13-Aug-13 3:00am

You are not answering my questions, why should I answer yours? :-)
—SA

Sweetynewb 13-Aug-13 7:53am

which question?

Sergey Alexandrovich Kryukov 13-Aug-13 10:06am

See above.
—SA

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

walterhevedeich · Answer 1 · 2013-08-12T20:17:00

I have asked a similar question[^] about unique values before and each of the answers have their own pros and cons. The question now will be how long do you want your unique values to be. Refer to the solutions on the link.

Edit:
With regards to your comment, why not just create the first characters of your division code, create the unique code, and then concatenate? Will the following be sufficient?

C#

string uniqueCode = System.Guid.NewGuid().ToString(); //E6ED1CBC-5FB3-4A1C-AD3C-5551F3836536
string divisionCode = "EM_T"; //or other value depending on your division name

// And then the final divisionCode will be divisionCode + uniqueCode, which in this case, will be
// EM_TE6ED1CBC-5FB3-4A1C-AD3C-5551F3836536