need help extracting this part

finalight · #1 (**permalink**) 05-20-2008

Code:

           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

aju_kup · #2 (**permalink**) 05-20-2008

Code:

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) }'

Ygor · #3 (**permalink**) 05-20-2008

Try...

Code:

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

penchal_boddu · #4 (**permalink**) 05-20-2008

Try this,

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

Thanks
Penchal

finalight · #5 (**permalink**) 05-20-2008

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

Ygor · #6 (**permalink**) 05-20-2008

Quote:

Originally Posted by finalight

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

Which post are you referring to?

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

Code:

$ 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

$

finalight · #7 (**permalink**) 05-20-2008

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

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
Extracting part of a string	sam_78_nyc	Shell Programming and Scripting	8	04-25-2007 08:37 PM
Extracting part of the basename	madhunk	Shell Programming and Scripting	3	02-13-2007 11:54 AM
extracting from tar.bz2	Raom	UNIX for Advanced & Expert Users	1	03-07-2006 10:33 AM
extracting uncommon part between two files	sabyasm	Shell Programming and Scripting	2	11-06-2005 01:25 PM
extracting from a string	preetikate	Shell Programming and Scripting	1	03-11-2004 08:08 AM

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode	Rate This Thread:


	Powered by