B
bluegrassstateworker
I have a field containing a variable-length string from 8 -17
characters. My difficulty is that when I sort them, I would like to
group them based on on the section of digits just before the last.
The last digit may represent a change to the original. For example,
the first three entries would be grouped together:
123 (=original number)
123 1 (a modification to the original 123)
123 2 (a second modification to the original 123)
These would also be grouped together but are of a different format.
P123555
P123555 1
P123555 2
Any ideas how to achieve this grouping would be appreciated.
characters. My difficulty is that when I sort them, I would like to
group them based on on the section of digits just before the last.
The last digit may represent a change to the original. For example,
the first three entries would be grouped together:
123 (=original number)
123 1 (a modification to the original 123)
123 2 (a second modification to the original 123)
These would also be grouped together but are of a different format.
P123555
P123555 1
P123555 2
Any ideas how to achieve this grouping would be appreciated.