Originally Posted by
June7
I still don't know why XX-11 was dropped from XX-11A222 but none of the others drop the XX- or YY- prefix.
Does that list represent every possible configuration for values?
Examples of rules for parsing a string:
First 4 characters.
Start with character after first hyphen and end with character before second hyphen.
etc.
Let`s sum up, what i have done after read your post.
Below you will find some categories.
Additionally i attach category.zip to this subject file which already have inputted the same but there are colored a core for red colour
For some categories i decided to follow only for some letters, digits(numbers) becouse core is still the same, but only size of screen will be changing for the choosen models.
I think the attached list in XLS show you all possible configuration.
In my opinion i think it should be go like this, but i`m not programmer and i haven't any knowledge about IF,OR,AND etc...
For category A and B there are the same rule:
start with letters after first hyphen, skip the first two numbers and after the last number skip the rest
Or
Start with letters after first hyphen skip first letter, skip two numbers and after the last numbers skip the rest
For category C
Start with letters, include hyphen, include letters and numbers but skip after numbers rest of the characters
For category D
Start with letters, include hyphen, include numbers and letters and include one number, after that skip rest of characters
For Category E
Start with letters, include hyphen, include all of the characters, and finish on the last digits.
For Category F
Start with letters, include hyphen, include all of the characters, and finish on the last digits and start with letters, include hyphen, letters and finished after your first pack of digits.
Code:
| CAT A. |
|
| AB-B21CD0C |
| AB-32BCD000D |
| AB-26BC0DE |
| AB-00B000C |
| AB-00BC000D |
| AB-00C000D |
| AB-B00C0D |
| AB-B00CD0E |
| AB-B00CDE00 |
| AB-B00E0D |
| AB-B00CD00E |
| AB-B00CD0EF |
|
|
| CAT B. |
|
| AB-B00CD00E |
| AB-B00DE00F |
| AB-B00C00D |
|
| CAT C. |
|
| BC-CD00EF0-G |
| BC-CD00FG0-H |
|
| CAT D. |
|
| CD-123DD0FGH |
| CD-123DD0FGJ |
| CD-120DD0FGI |
| CD-127DD0FGB |
| CD-127DD0FGY |
| CD-128DD0FGD |
|
| CAT E. |
|
| DE-AB1234ABC |
| DE-ABC123ABC |
| DE-ABC234ABC |
| DE-CD1234ABC |
| DE-ABD123ABD |
|
| CAT F. |
|
| EF-A123BC-D |
| EF-A234BD-E |
| EF-A345BE-F |
| EFG-BC123DEF |
Windows XP 
Access 2007
Reply With Quote
