How to sort a column on numeric part of string

thepurpleblob

I have a column that comprises of values which are a few alpha characters and a string (example, SC12345). I want to sort on the numeric part, completely ignoring the alpha part.

Can this be done?

I looked at plugins and thought 'numString' might be close but I haven't a clue from the docs how to use it. It looks like it might not work for single columns as there is no example.

kthorngren

I've successfully used the natural sorting plugin for this type of data.

Kevin