Recent content by 90405

identify duplicate strings: a numeric string within another Is there a method to identify a numeric string within another numeric string and then express "duplicate" As exmple data: 097102105111114100105112101108108101 could appear in another string...

I have a problem in which I would like to extract every odd digit in the length of a numeric string and then return this as a combined result Could a simple function be derived for Excel? Below is given an example: Original Odd digit Result 0 1 0 9 2 7 3 7 1 4 0 5 0 2 6 1 7 1 0 8 5 9...

Could you explain the application of the autonumber and primary key as I am a novice and I am getting a bit confused trying to understand and distinguish the advantages and disadvantages, i.e. if I should let access assign an automatic autonumber or otherwise create an autonumber perhaps derived...

I would appreciate if anyone could suggest a method to remove duplicate records, I am still a bit of a nove and still would appreciate a simple as possible method. But essentially, the company can have similar: product sectors provincial locations telephone numbers I would also be...

This simplified everything ...! After I take two valium pills and get my mental brain database which is a Pentium (at the momemnt working overclocked...!) to analyse all this.

I would appreciate the best method to input images corresponding to unique images. Product name: Product code: Each product code, has 3 images 1 image in GIf 2 image in Jpeg If I establish a table with fields: Product name Product code Image name (format) xxxxxx.gif or xxxxxx.jpeg...

I am still a bit of novice with Access, and what you stated is correct, but I just wanted to convert the alphanumeric data to numeric code since I believe it also facilitates indexing/ processing. Do you have any suggestions as I can remove duplicates in a databse? both exact and near exact 3...

Just something further for your interesdt **************** hashing The term you selected is being presented by searchDatabase.com, a TechTarget site for Database professionals. Hashing is the transformation of a string of characters into a usually shorter fixed-length value or key...

I guess I was trying to improvise a very simple empirical "hash" method, before I moved onto more complex methods. I was moving in one direction and had one intention, but I guess in the cross-communication and maybe some misinterpretation, some unexpected solutions were derived in a creative...

for example: a company name such as: ApisSRL would be converted into a numeric code ???? and I would extract (select) digits from this numeric code, derived from every odd positioned digit and then recombine it 0-6-5-1-1-2-1-0-5-1-15083082076 I get from above odd positions deriving a...

Could you explain your code, since the results return only 4 digits maximum? thanks

Thank you for the warning, but I was thinking of extracting every odd digit (the digit in the 1st, 3rd, 5th, 7th etc position) and not adding them, but selecting the actual number in that position? worth it? to create a unique numeric code (maybe 10 digits in length)

I have already removed any non alphanumeric characters, but lower case might be influencing it? I'll try your suggestion with lower case thankyou for the effort

I tested it on the raw data, but apparently do not get consistent results taking into account obvious differences in characters: ApisSRL ApisSrl ApisSrl ApisSrl ApisSrl corresponding to 639 703 638 702 702 or: 3PRappresentanzaCommercioEsteroSRL 3PRappresentanzaCommercioEsteroSRL...

to convert the text string into a "unique" numeric code The duplicate problem, is not a priority for the moment, I am more interested in a solution to convert the text string into a "unique" numeric code suitable to be used for a Primary Key in Access