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.