Skip to Content
0
Former Member
Feb 13, 2009 at 08:47 PM

Sorting of alphanumeric data

557 Views

Hi,

I have data which contains letters, numbers, and some special characters. String length is not fixed. I want to sort it after certain number of characters.

e.g.

A-BC-111 these first characters/pattern is fixed but after that pattern and number of characters are not fixed.

A-BC-111-A105-13134A

A-BC-111-A001-1

A-BC-111-A002-15

A-BC-111-A001-10

A-BC-111-A001-11

A-BC-111-A001-12

A-BC-111-B001-2

A-BC-111-A001-3

A-BC-111-A001-2

A-BC-111-B001-1

The above records should be sorted in following order

A-BC-111-A001-1

A-BC-111-A001-2

A-BC-111-A001-3

A-BC-111-A001-10

A-BC-111-A001-11

A-BC-111-A001-12

A-BC-111-A002-15

A-BC-111-A105-13134A

A-BC-111-B001-1

A-BC-111-B001-2

I have number of different patterns. Sorting starts from different positions.

Any help will be appreciated.

Thanks.