Hi,
How do I get group headers, form a text file to a table, to be listed in the same row as the information directly below the header?
I have a text file from another program that I need to import to access. The file has group headers with Tail numbers that I need to be associated with the part and serial numbers below it. The amount of lines below each header is not always the same. I know how to extract either the aircraft number or the part serial number, but I do not know how to put the header with the part and serial number
for instance
Aircraft N3456
456723-101 FD34566
566788-303 GS23445
Aircraft N5684
566788-303 GS23445
456723-101 GD23478
566788-303 GS45444
434545-444 JI345345
How do i get the above information to look like this in table?
N3456 456723-101 FD34566
N3456 566788-303 GS23445
N5684 566788-303 GS23445
N5684 456723-101 GD23478
N5684 566788-303 GS45444
N5684 434545-444 JI345345
Thank you very very much
Steve
How do I get group headers, form a text file to a table, to be listed in the same row as the information directly below the header?
I have a text file from another program that I need to import to access. The file has group headers with Tail numbers that I need to be associated with the part and serial numbers below it. The amount of lines below each header is not always the same. I know how to extract either the aircraft number or the part serial number, but I do not know how to put the header with the part and serial number
for instance
Aircraft N3456
456723-101 FD34566
566788-303 GS23445
Aircraft N5684
566788-303 GS23445
456723-101 GD23478
566788-303 GS45444
434545-444 JI345345
How do i get the above information to look like this in table?
N3456 456723-101 FD34566
N3456 566788-303 GS23445
N5684 566788-303 GS23445
N5684 456723-101 GD23478
N5684 566788-303 GS45444
N5684 434545-444 JI345345
Thank you very very much
Steve