Decode a table to an array

[Andreea1]

I have recently run into a problem at work in regards to organizing information for some variables in a table and sorting them based on priority values...

For example:

Case ID: 0 1 2 3 4
1 (2 3) (1 2) (5 1) **the first number in the () is the priority*
2 **the second number is the variable id**
3

So from up above (I made it shorter than mine), I have a table with 8 columns for the different cases and 30 rows for the different conditions possible. I am trying to figure out a way to create some type of function that will be able to run through the row and pick the case with the highest priority first (from 1-8), and output the case ID, the priority, and the second number within the brackets.

I thought about creating a decoder that will sort the values and give an array with the outputs, but I know there must be a smarter way to sort the data.

Any thoughts or ideas? Is more clarification needed? Any help is truly appreciated!

[LB]

You should separate these concepts into classes, or plain structs at the very least. Trying to deal with a serialized table will be a mess.