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,SBR_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