help extracting text from file

firefox2k2 · July 21, 2012, 3:17am

Hello I have a large file with lines beginning with 552, 553, 554, below is a small sample, I need to extract the data you can see below highlighted in bold from this file on the same location on every line and output it to a new file.

Thank you in advance for any help

55201KL 000787350120720  KL32   21547XA                            MU   LKW-2P  S000000V            0000000000                 
55301000006110012071800089123000000000001300000I                                                                               
554011207200000000001300 1207230000000000000 1207240000000001300 1207250000000000012 1207260000000000077 1208130000000001300   
554011208140000000000808 1208150000000000700 1208160000000001200 1208170000000001300 0000000000000000000 0000000000000000000
5520150 000000164120720  6L1W    6519AX                            GS           E000000V1738621     0000000000                 
55301000000361312071800540451000000000000300000I                                                                               
554011207200000000000613 1207230000000000500 1207240000000000002 1207250000000005600 1207260000000000078 1207270000000000008   
554011207300000000000770 1207310000000000100 1208010000000000060 1208020000000000500 1208030000000000700 0000000000000000000

I would like it to look like this if possible

KL32   21547XA  MU                                                                                       
120720 1300 120723 0000 120724 1300 120725 0012 120726 0077 120813 1300   
120814 0808 120815 0700 120816 1200 120817 1300 000000 0000 000000 0000
                                                                                                                         
6L1W    6519AX GS                                                                                             
120720 0613 120723 0500 120724 0002 120725 5600 120726 0078 120727 0008  
120730 0000 120731 0100 120801 0060 120802 0500 120803 0700 000000 0000

elixir_sinari · July 21, 2012, 3:46am

awk '
/^552/{print $3, $4, $5}
/^554/{
printf("%s %s ",substr($1,6,6),substr($1,length($1)-3))
for(i=2;i<=NF;i++)
 printf("%s %s ",substr($i,1,6),substr($i,length($i)-3))
print ""
}' inputfile

firefox2k2 · July 23, 2012, 2:43am

elixir_sinari:

awk '
/^552/{print $3, $4, $5}
/^554/{
printf("%s %s ",substr($1,6,6),substr($1,length($1)-3))
for(i=2;i<=NF;i++)
 printf("%s %s ",substr($i,1,6),substr($i,length($i)-3))
print ""
}' inputfile

Hi thanks for the help, tried this but get a syntax error when running