Protcol ID/NO Site ID Subject Id DOB Acc NO. SC Date ONC_AP/01234-1 101 ABC 15-Jul-78 2345671671 16/09/22 ONC_AP/01234-2 102 BBC 21-Jun-87 9900696375 18/09/22 ONC_AP/01234-3 103 BBD 10-Sep-03 6474893763 17/09/22 ONC_AP/01234-4 104 BAC 18/08/90 7653225839 16/09/22 ONC_AP/01234-5 105 ACF 16/07/50 6432875875 14/09/22 ONC_AP/01234-6 101 TGU 16/08/55 5627483920 19/09/22 ONC_AP/01234-7 102 JKL 12/07/08 3456098347 18/09/22 ONC_AP/01234-8 101 AFN 23/02/80 8765234509 18/09/22 ONC_AP/01234-9 104 SLR 07/05/86 5647389098 17/09/22 ONC_AP/01234-10 105 ASR 19/12/83 2345671671 18/09/22 ON1_AP/01234-2 10A _ABC 12-Jul-78 9900696375 19/09/22 O1C_AP/01234-2 A02 1BC 20-Jun-87 6474893763 18/09/22 1NC_AP/01234-4 #03 _1BD 10-Sep-03 7653225839 19/09/22 ONC1_AP/01234-6 1Q4 _111 18/08/90 6432875875 15/09/22 ONC_1P/01234-6 ab5 AC- 16/07/50 5627483920 13/09/22 ONC_A1/01234-7 a@c 101_TGU 16/08/55 3456098347 16/09/22 ONC-01/01234-7 aaa 102-JKL 12/07/08 8765234509 19/09/22 ONC_#P/01234-9 a0a 103@AFN 23/02/80 5647389098 15/09/22 ONC_AP*01234-10 #3# 102_a10- 07/05/86 2345671671 17/09/22 ONC_AP/A1234-2 10_ ASR_100 19/12/83 9900696375 19/09/22 ONC_AP/0A234-1 101- /scf 15-Sep-78 6474893763 16/09/22 ON1_AP/01A34-2 106 ACY 21-Mar-87 7653225839 18/09/22 O1C_AP/012A4-2 107 BBE 10-Mar-03 6432875875 17/09/22 1NC_AP/0123A-4 108 BBY 18/01/90 5627483920 16/09/22 ONC1_AP/01234_6 109 AAC 16/02/50 3456098347 14/09/22 ONC_1P/AABBC-6 110 ACH 16/03/55 8765234509 19/09/22 ONC_A1/01234-A 111 TIU 12/12/08 5647389098 18/09/22 ONC-01/01234$7 112 JLL 23/10/80 2345671671 18/09/22 ONC_AP@01234-9 113 CFN 07/15/1986 9900696375 17/09/22 123_01/01234-6 114 SCR 01-Sep-78 6474893763 18/09/22 ONC-AP/ABCDE-2 115 ASO 02-Mar-87 7653225839 19/09/22 ONC_AP/01234-E 116 ACY 03-Mar-03 6432875875 18/09/22 123_AP/01234-6 117 BBE 04/01/90 5627483920 19/09/22 ONC_AP/12345-C 118 BBY 05/02/50 3456098347 15/09/22 ON _AP/01234-5 119 AAC 06/03/55 8765234509 13/09/22 ONC_ /01234-4 120 ACH 07/12/08 5647389098 16/09/22 ONC_ 121 TIU 08/10/80 5627483920 19/09/22 ONC_AP/ 122 JLL 09/15/1986 3456098347 15/09/22 ONC_AP/ABC34-4 123 CFN 17/15/1986 8765234509 17/09/22 This my raw data , in this data , i want find the correct protocol format my protocol format is first letters 3 alphabets,4th position is underscore, 5th to 6th position is alphabets,7th position backward slash , after 7th to 12th position value values after 13th position '-' , 14th to 15th position value. eg (apc_ec/01234-43), how to verify each value in protocol variable , anyone can please me .
... View more