I just had a few questions. You mentioned that you must exclude dashes and "&" symbols, but what about other symbols like a period. I have guessed at what the part numbers would look like on the following, would this be correct?


ALLO-01 ALLOY INDUSTRIAL CONTRACTORS
ALLO-02 A.L. LOYD INC.
ALLO-03 A & L LOYD INDUSTRIES INC.

If this is correct, then you have to exclude periods. Or what about spaces? I suppose there could also be numbers in the name:

123C-01 123 CONTRACTORS LLC INC
123C-02 123 COMPARTMENTS UNLIMITED INC.

I would presume the possibilities for company names would include the following

Letters: A - Z and a - z
Numbers: 0 - 9
Symbols: &, period, comma, space, dash

Inorder to code this program we have to have all the details and possibilities. Please be very specific. The example you gave, looked like it was already in alphabetical order. Does the code need to alphabetize the list? Also, what about upper and lower case letters? If we have a company list like this:

BECK-01 Beck HPC Inc.

or

Beck-01 Beck HPC Inc.

Just from your example, it looks like you would like the customer ID to be capitalized, is that correct?

This is just a list of a few questions that would make it more clear. Thanks!