Now for A04 there are multiple lines strating by the same
how can i only pick characters from the first A04 Line
Used the above but its reading the last line of the A04 Lines.Need do the same for the other A04 lines.
Code:
A0401AA001AMERICAN AIR7975S HK18DEC0800 1340 2DOHDOHA ORDCHICAGO/O HARIN X0 777 07128F AC:QATAR AIRWAYTK:YJT:14.40ANL:AMERICAN AIRLINES ACL:QATAR AIRWAYS DDL:18DEC14
A0402AA001AMERICAN AIR3177S HK18DEC1820 2105 2ORDCHICAGO/O HARSATSAN ANTONIO DN O0 CR7 T3 01043F AC:ENVOY AIR ASTK:YJT:02.45ANL:AMERICAN AIRLINES ACL:ENVOY AIR AS AMERICAN EAGLE DDL:18DEC14
A0403AA001AMERICAN AIR3137S HK01JAN1400 1715 2DENDENVER ORDCHICAGO/O HARDN X0 CR7 00887F AC:ENVOY AIR ASTK:YJT:02.15ANL:AMERICAN AIRLINES ACL:ENVOY AIR AS AMERICAN EAGLE DDL:01JAN15
A0404AA001AMERICAN AIR7974S HK01JAN1925 1740 3ORDCHICAGO/O HARDOHDOHA IN O0 777 T3 07128F AC:QATAR AIRWAYTK:YJT:13.15ANL:AMERICAN AIRLINES ACL:QATAR AIRWAYS DDL:01JAN15
Code:
Mid(TextLine, 47, 26)