How to Add seq as alphabetic
Posted: Thu Jul 30, 2015 2:51 pm
Hi,
Good evening!
Please help me out to put the sequence as A,B,C..etc.is it possible to put sequence as Alphabetic using sort
I Have input like this.
based on the first 11 digits i want to put the 25th position with sequence as A,B,C..
Output should be like below:
=
Please help me out sort systanx for the above case.
Regards,
kk
Good evening!
Please help me out to put the sequence as A,B,C..etc.is it possible to put sequence as Alphabetic using sort
I Have input like this.
=COLS> ----+----1----+----2----+----3----+----4----+-
****** ***************************** Top of Data ****
000001 50015662008 00001-IBW82U20150702
000002 50015662008 00001-IBVWME20150702
000003 50015662008 00001-IBVXME20150702
000004 50015662008 00001-IBVYME20150702
000005 50015662001 00001-IBVAME20150702
000006 50015662001 00001-IBVBME20150702
000007 50015662001 00001-IBVBME20150702
****** **************************** Bottom of Data **
****** ***************************** Top of Data ****
000001 50015662008 00001-IBW82U20150702
000002 50015662008 00001-IBVWME20150702
000003 50015662008 00001-IBVXME20150702
000004 50015662008 00001-IBVYME20150702
000005 50015662001 00001-IBVAME20150702
000006 50015662001 00001-IBVBME20150702
000007 50015662001 00001-IBVBME20150702
****** **************************** Bottom of Data **
based on the first 11 digits i want to put the 25th position with sequence as A,B,C..
Output should be like below:
=
COLS> ----+----1----+----2----+----3----+----4----+----5-
****** ***************************** Top of Data *********
000001 50015662008 A00001-IBW82U20150702
000002 50015662008 B00001-IBVWME20150702
000003 50015662008 C00001-IBVXME20150702
000004 50015662008 D00001-IBVYME20150702
000005 50015662001 A00001-IBVAME20150702
000006 50015662001 B00001-IBVBME20150702
000007 50015662001 C00001-IBVBME20150702
****** ***************************** Top of Data *********
000001 50015662008 A00001-IBW82U20150702
000002 50015662008 B00001-IBVWME20150702
000003 50015662008 C00001-IBVXME20150702
000004 50015662008 D00001-IBVYME20150702
000005 50015662001 A00001-IBVAME20150702
000006 50015662001 B00001-IBVBME20150702
000007 50015662001 C00001-IBVBME20150702
Please help me out sort systanx for the above case.
Regards,
kk