D
Dr. Darrell
I have a list similar to the following:
DopOrder^14131^1^
DopOrder^14132^2^
DopOrder^14132^3^
DopOrder^14132^4^
DopOrder^14134^1^
DopOrder^14134^2^
DopOrder^14134^3^
DopOrder^14134^43^
I only want to work with the numbers that end with ^1^ and ^ (the largest
number) ^ for each of the prefix nimbers, (14132 & 14134). Please note that
the list will be several thousand numbers long.
I can filter the numbers ending with ^1^ by using a wild card such as "
DopOrder^*^1^ ".
My question is; is there a wildcard for selcting the largest number in a list?
Thanks,
Darrell
DopOrder^14131^1^
DopOrder^14132^2^
DopOrder^14132^3^
DopOrder^14132^4^
DopOrder^14134^1^
DopOrder^14134^2^
DopOrder^14134^3^
DopOrder^14134^43^
I only want to work with the numbers that end with ^1^ and ^ (the largest
number) ^ for each of the prefix nimbers, (14132 & 14134). Please note that
the list will be several thousand numbers long.
I can filter the numbers ending with ^1^ by using a wild card such as "
DopOrder^*^1^ ".
My question is; is there a wildcard for selcting the largest number in a list?
Thanks,
Darrell