Server-side sorting on a DB field containing an array

jimbob72

I need to be able to sort a table on a column. The DB field that populates the column is an array containing about 260 comma-delimited numbers (e.g. 0.002345,0.021242,0.124324, etc.) and another 260 or so of empty values (e.g. ,,,,,). I need to sort the column on the last actual value in each array.

I have tried creating a type-based sorting plugin to derive the last value in the array and sort on that basis, but I'm a bit stuck. I understand how to do this in PHP but not JS.

Any help would be hugely appreciated.