Hi Rob
You can parse the string looking for and counting the occurrences of any
string. However in this case I presume you do not know what the string(s)
are or do you ? If you do then the procedure is straightforward - please
post what the position is.

--
Cheers
Nigel



"Rob Hargreaves" wrote in message
...
I have a string as below


SBR_1_Ammonia,SBR_2_MLSS,SBR_4_Ammonia,SBR_3_Ammon ia,SBR_1_MLSS,SBR_4_MLSS,S
BR_2_Ammonia,SBR_3_MLSS

I need to get the computer to categorise and order the string with no help
from an inteligent human!

We all know through study of the string that we have 2 categories

-Ammonia

-MLSS

and we can see there are 4 in each category in the dtring above, we find
it
easy because they are all numbered although in the worng order and they
are
all the entries in eac category are the same other than a number mid
string.

Is it possible to parse the string into 2 strings - 1 for each category
and
order them based on their percentage match of characters the fact that the
remaining % of any string which doesnt match will be a number which can be
used to re order.

For example - the 2 strings will look like so -

SBR_1_Ammonia,SBR_2_Ammonia,SBR_3_Ammonia,SBR_4_Am monia

&

SBR_1_MLSS,SBR_2_MLSS,SBR_3_MLSS,SBR_4_MLSS

Thanks for your suggestions. Sorry for keeping asking these mind boglers!

Rob