need help extracting this part

Shell Programming and Scripting
1 
           JADE TRADER       143W       MYPEN  40   HC   M    X10    28    7	1      0
                                        MYPEN  20   GP   X    X10    15    2	1      0
                                        MYPEN  40   GP   X    X10    28    7	1      0
                                        MYPEN  20   GP   L    X10    15    2	1      0
       BUNGA TERATAI 3       5055       NZLYT  20   GP   X    X11    17    8	1      0
          MOL SPLENDOR      0307A       MUPLU  40   HC   X    X11    10    2	2      0
                                        MUPLU  40   HC   U    X11    10    2	1      0

i doing a script to extract the result and want the result to be like this

       JADE TRADER       143W       MYPEN  40   HC   M    X10    28    7	1      0
       JADE TRADER       143W                                               MYPEN  20   GP   X    X10    15    2	1      0
       JADE TRADER       143W                                               MYPEN  40   GP   X    X10    28    7	1      0
       JADE TRADER       143W                                               MYPEN  20   GP   L    X10    15    2	1      0
   BUNGA TERATAI 3       5055       NZLYT  20   GP   X    X11    17    8	1      0
      MOL SPLENDOR      0307A       MUPLU  40   HC   X    X11    10    2	2      0
      MOL SPLENDOR      0307A       MUPLU  40   HC   U    X11    10    2	1      0

so how can I achieve this result, given that I do not know how many subsets are there for each of the first field..?

2 
awk ' NF > 9 { m=$1 " " $2 " " $3;
        printf("%s %s %s %s %s %s %s %s %s %s \n" ,m, $4, $5, $6, $7, $8, $9, $10, $11, $12)  ; next }
        { printf("%s %s %s %s %s %s %s %s %s %s \n" ,m, $1, $2, $3, $4, $5, $6, $7, $8, $9) }'
3

Try...

awk '{a=substr($0,1,40);print (a~"[^ ]"?p=a:p) substr($0,41)}' file1 >  file2
4

Try this,

awk ' NF > 10 { val1=$1;val2=$2;val3=$3; print $0 ; next}
{print val1,val2,val3,$0}' filename

Thanks
Penchal

5

awk: syntax error near line 2
awk: bailing out near line 2

6

Which post are you referring to?

This is what I get a the ksh prompt (represented by "$")....

$ cat file1
           JADE TRADER       143W       MYPEN  40   HC   M    X10    28    7    1      0
                                        MYPEN  20   GP   X    X10    15    2    1      0
                                        MYPEN  40   GP   X    X10    28    7    1      0
                                        MYPEN  20   GP   L    X10    15    2    1      0
       BUNGA TERATAI 3       5055       NZLYT  20   GP   X    X11    17    8    1      0
          MOL SPLENDOR      0307A       MUPLU  40   HC   X    X11    10    2    2      0
                                        MUPLU  40   HC   U    X11    10    2    1      0

$ awk '{a=substr($0,1,40);print (a~"[^ ]"?p=a:p) substr($0,41)}' file1 > file2
$ cat file2
           JADE TRADER       143W       MYPEN  40   HC   M    X10    28    7    1      0
           JADE TRADER       143W       MYPEN  20   GP   X    X10    15    2    1      0
           JADE TRADER       143W       MYPEN  40   GP   X    X10    28    7    1      0
           JADE TRADER       143W       MYPEN  20   GP   L    X10    15    2    1      0
       BUNGA TERATAI 3       5055       NZLYT  20   GP   X    X11    17    8    1      0
          MOL SPLENDOR      0307A       MUPLU  40   HC   X    X11    10    2    2      0
          MOL SPLENDOR      0307A       MUPLU  40   HC   U    X11    10    2    1      0

$

If on Solaris, use nawk.

7

oh nvm, because the data i post is just a part of the whole file actually..i was trying to find some other way to do it