誰能幫我處理如下的文件？(以文件的某一行排序后重組)謝謝了!!

skycity0210

第一個文件是以含“NUM=”的行來排序，如下
TOOLS {
    NUM=1
    SHAPE=HOLE
    TYPE=PLATED
    TYPE2=STANDARD
    MIN_TOL=3.15
    MAX_TOL=3.15
    BIT=
    FINISH_SIZE=12
    DRILL_SIZE=17.71653543307087
    SLOT_LENGTH=0
}

TOOLS {
    NUM=2
    SHAPE=HOLE
    TYPE=PLATED
    TYPE2=STANDARD
    MIN_TOL=3.15
    MAX_TOL=3.15
    BIT=
    FINISH_SIZE=28
    DRILL_SIZE=33.46456692913386
    SLOT_LENGTH=0
}

TOOLS {
    NUM=3
    SHAPE=HOLE
    TYPE=PLATED
    TYPE2=STANDARD
    MIN_TOL=3.15
    MAX_TOL=3.15
    BIT=
    FINISH_SIZE=22
    DRILL_SIZE=27.55905511811024
    SLOT_LENGTH=0
}

TOOLS {
    NUM=4
    SHAPE=HOLE
    TYPE=PLATED
    TYPE2=STANDARD
    MIN_TOL=3.15
    MAX_TOL=3.15
    BIT=
    FINISH_SIZE=40
    DRILL_SIZE=45.2755905511811
    SLOT_LENGTH=0
}

TOOLS {
    NUM=5
    SHAPE=HOLE
    TYPE=NON_PLATED
    TYPE2=STANDARD
    MIN_TOL=3.15
    MAX_TOL=3.15
    BIT=
    FINISH_SIZE=35
    DRILL_SIZE=41.33858267716536
    SLOT_LENGTH=0
}
第二個文件要以含“DRILL_SIZE=”來排序，并重組“NUM=”的那行，效果如下
TOOLS {
    NUM=1
    SHAPE=HOLE
    TYPE=PLATED
    TYPE2=STANDARD
    MIN_TOL=3.15
    MAX_TOL=3.15
    BIT=
    FINISH_SIZE=12
    DRILL_SIZE=17.71653543307087
    SLOT_LENGTH=0
}

TOOLS {
    NUM=2
    SHAPE=HOLE
    TYPE=PLATED
    TYPE2=STANDARD
    MIN_TOL=3.15
    MAX_TOL=3.15
    BIT=
    FINISH_SIZE=22
    DRILL_SIZE=27.55905511811024
    SLOT_LENGTH=0
}

TOOLS {
    NUM=3
    SHAPE=HOLE
    TYPE=PLATED
    TYPE2=STANDARD
    MIN_TOL=3.15
    MAX_TOL=3.15
    BIT=
    FINISH_SIZE=28
    DRILL_SIZE=33.46456692913386
    SLOT_LENGTH=0
}

TOOLS {
    NUM=4
    SHAPE=HOLE
    TYPE=PLATED
    TYPE2=STANDARD
    MIN_TOL=3.15
    MAX_TOL=3.15
    BIT=
    FINISH_SIZE=35
    DRILL_SIZE=41.33858267716536
    SLOT_LENGTH=0
}

TOOLS {
    NUM=5
    SHAPE=HOLE
    TYPE=NON_PLATED
    TYPE2=STANDARD
    MIN_TOL=3.15
    MAX_TOL=3.15
    BIT=
    FINISH_SIZE=40
    DRILL_SIZE=45.2755905511811
    SLOT_LENGTH=0
}
謝謝老大了!

skycity0210

好像只用awk有點不夠用，awk的排序函數(shù)還不太會用，有哪位老大有好的思路？

dbcat

1. cat -n file |sed -n '/.\{2\}\..\{10,\}$/p' | sort -t"=" -k2 | cut -f1 | xargs -i awk 'NR>{}- 10&&NR<{}+3{print}' file >tmp

復(fù)制代碼

1. seq 1 5 |xargs -i echo "NUM={}"|xargs -i  sed 's/NUM\=[1-5]\{1\}$/{}/' tmp | awk '{k=0;while(k<6){if(NR < 60*k
   
2. + 12*k +13  && NR > 60*k + 12*k ){print;}k++;}}'

復(fù)制代碼

$ seq 1 5 |xargs -i echo "NUM={}"|xargs -i  sed 's/NUM\=[1-5]\{1\}$/{}/' tmp | awk '{k=0;while(k<6){if(NR < 60*k + 12*k +13  && NR > 60*k + 12*k ){print;}k++;}}'
TOOLS {
    NUM=1
    SHAPE=HOLE
    TYPE=PLATED
    TYPE2=STANDARD
    MIN_TOL=3.15
    MAX_TOL=3.15
    BIT=
    FINISH_SIZE=12
    DRILL_SIZE=17.71653543307087
    SLOT_LENGTH=0
}
TOOLS {
    NUM=2
    SHAPE=HOLE
    TYPE=PLATED
    TYPE2=STANDARD
    MIN_TOL=3.15
    MAX_TOL=3.15
    BIT=
    FINISH_SIZE=22
    DRILL_SIZE=27.55905511811024
    SLOT_LENGTH=0
}
TOOLS {
    NUM=3
    SHAPE=HOLE
    TYPE=PLATED
    TYPE2=STANDARD
    MIN_TOL=3.15
    MAX_TOL=3.15
    BIT=
    FINISH_SIZE=28
    DRILL_SIZE=33.46456692913386
    SLOT_LENGTH=0
}
TOOLS {
    NUM=4
    SHAPE=HOLE
    TYPE=NON_PLATED
    TYPE2=STANDARD
    MIN_TOL=3.15
    MAX_TOL=3.15
    BIT=
    FINISH_SIZE=35
    DRILL_SIZE=41.33858267716536
    SLOT_LENGTH=0
}
TOOLS {
    NUM=5
    SHAPE=HOLE
    TYPE=PLATED
    TYPE2=STANDARD
    MIN_TOL=3.15
    MAX_TOL=3.15
    BIT=
    FINISH_SIZE=40
    DRILL_SIZE=45.2755905511811
    SLOT_LENGTH=0
}

[ 本帖最后由 dbcat 于 2005-11-16 22:26 編輯 ]

skycity0210

謝謝老大了，能不能大概解釋一下思路，看的有點暈，^_^

dbcat

First,以含“DRILL_SIZE=”來排序:

1. cat -n file |sed -n '/.{2}..{10,}$/p' | sort -t"=" -k2 | cut -f1 | xargs -i awk 'NR>{}- 10&&NR<{}+3{print}' file >tmp

復(fù)制代碼

$cat tmp
TOOLS {
    NUM=1
    SHAPE=HOLE
    TYPE=PLATED
    TYPE2=STANDARD
    MIN_TOL=3.15
    MAX_TOL=3.15
    BIT=
    FINISH_SIZE=12
    DRILL_SIZE=17.71653543307087
    SLOT_LENGTH=0
}
TOOLS {
    NUM=3
    SHAPE=HOLE
    TYPE=PLATED
    TYPE2=STANDARD
    MIN_TOL=3.15
    MAX_TOL=3.15
    BIT=
    FINISH_SIZE=22
    DRILL_SIZE=27.55905511811024
    SLOT_LENGTH=0
}
TOOLS {
    NUM=2
    SHAPE=HOLE
    TYPE=PLATED
    TYPE2=STANDARD
    MIN_TOL=3.15
    MAX_TOL=3.15
    BIT=
    FINISH_SIZE=28
    DRILL_SIZE=33.46456692913386
    SLOT_LENGTH=0
}
TOOLS {
    NUM=5
    SHAPE=HOLE
    TYPE=NON_PLATED
    TYPE2=STANDARD
    MIN_TOL=3.15
    MAX_TOL=3.15
    BIT=
    FINISH_SIZE=35
    DRILL_SIZE=41.33858267716536
    SLOT_LENGTH=0
}
TOOLS {
    NUM=4
    SHAPE=HOLE
    TYPE=PLATED
    TYPE2=STANDARD
    MIN_TOL=3.15
    MAX_TOL=3.15
    BIT=
    FINISH_SIZE=40
    DRILL_SIZE=45.2755905511811
    SLOT_LENGTH=0
}

Second,重組“NUM=”的那行a

1. seq 1 5 |xargs -i echo "NUM={}"|xargs -i  sed 's/NUM=[1-5]{1}$/{}/' tmp | awk '{k=0;while(k<6){if(NR < 60*k + 12*k +13  && NR > 60*k + 12*k ){print;}k++;}}'

復(fù)制代碼

****ps:Shell Code Too long

skycity0210

seq 是什么命令？我用的c-shell,沒見過seq，請老大指教!
代碼實用就行^_^

dbcat

csh............
This script is for bash ^_^
$seq 1 5
1
2
3
4
5

In csh try:
??

[ 本帖最后由 dbcat 于 2005-11-16 22:36 編輯 ]

技安

awk ' BEGIN { FS="[\n=]" ; RS=""} { print $3 } ' a | sort -n > c

for i in `cat c ` ; do

awk ' BEGIN { FS="[\n=]" ; RS=""} { a[$3]=$0 } END { print a['$i'] }  ' a

done

-------------------

如果 num 有相同的就不行了、、、，

[[i] 本帖最后由 技安 于 2005-11-16 22:55 編輯 [/i]]

技安

暈、我。。。。。。。。。。。。還以為、第一個文件，也是亂的呢。

技安

awk -F= ' $1 ~ /DRILL_SIZE/ { print $2 } ' a | sort -n > c

for i in ` cat c ` ; do

awk ' BEGIN { FS="[\n=]" ; RS=""} {  a[$19]=$0 } END { print a["'$i'"] } ' a

done

[[i] 本帖最后由 技安 于 2005-11-16 23:09 編輯 [/i]]