Sorting of alphanumeric data

[#1]

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.

[Former Member]

Problem is solved by someone else and not from the replies I got on forum. But thanks for reply.

[Former Member]

Hi Sushama

I am hoping you can let me know how you got around this?

Thanks very much

duffey