awk 칼럼 바꾸기 (sed)

데이터 파일 111

admin@ys /home/ys/script $ cat 111 

1703 doc

 340 search

 250 company

 240 paper

  54 member

  36 form

  14 mreport

  14 knowledge

   8 redirect

   7 cover

   6 template

   6 syndi

   6 robots.txt

   5 mmember

간단히 칼럼만 교체, 바로 출력

admin@ys /home/ys/script $ cat 111 | sed 's/\ \ / /g'| sed 's/\ \ / /g'| sed 's/\ \ / /g'| sed 's/^\ /g' | awk -F"\ " ' !/^$/ {print $2" "$1 }'

doc 1703

search 340

company 250

paper 240

member 54

form 36

mreport 14

knowledge 14

redirect 8

cover 7

template 6

syndi 6

robots.txt 6

mmember 5

배열에 담았다가 출력

admin@ys /home/ys/script $ cat 111 | sed 's/\ \ / /g'| sed 's/\ \ / /g'| sed 's/\ \ / /g'| sed 's/^\ /g' | awk -F"\ " ' !/^$/ { a[$2]=a[$2]$1  } END { for (i in a) {print i, a[i] } } '

paper 240

redirect 8

knowledge 14

template 6

mreport 14

member 54

cover 7

robots.txt 6

search 340

doc 1703

syndi 6

mmember 5

company 250

form 36