求助

wtuter

现在如下文件:
10.99.1.186.txt:JHF_EXECUTION:6498672
10.99.1.176.txt:JHF_EXECUTION:6498488
10.99.1.186.txt:JHF_EXECUTION_BIND:6504342
10.99.1.176.txt:JHF_EXECUTION_BIND:6504314
10.99.1.186.txt:JHF_FORMULA:16309
10.99.1.176.txt:JHF_FORMULA:16308
10.99.1.186.txt:JHF_HEDGE_BIND:1217104
10.99.1.176.txt:JHF_HEDGE_BIND:1217069
10.99.1.186.txt:JHF_HEDGE_CUSTTRADE:21733
10.99.1.176.txt:JHF_HEDGE_CUSTTRADE:21461
10.99.1.186.txt:JHF_LEVERAGE_GROUP:3841816
10.99.1.176.txt:JHF_LEVERAGE_GROUP:3841368
10.99.1.186.txt:JHF_MAIL_ACTION_MAP:346362
10.99.1.176.txt:JHF_MAIL_ACTION_MAP:346348
10.99.1.186.txt:JHF_MAIL_ADDRESS:79548
10.99.1.176.txt:JHF_MAIL_ADDRESS:79542
10.99.1.186.txt:JHF_MOBILE_QUICKLOGIN:3319
10.99.1.176.txt:JHF_MOBILE_QUICKLOGIN:3318
10.99.1.186.txt:JHF_NET_BIND:4586761
10.99.1.176.txt:JHF_NET_BIND:4586759
10.99.1.186.txt:JHF_ORDER_BIND:9512979
10.99.1.176.txt:JHF_ORDER_BIND:9512472
10.99.1.186.txt:JHF_ORDER_NO_GENERATOR:21709
10.99.1.176.txt:JHF_ORDER_NO_GENERATOR:21708
10.99.1.186.txt:JHF_PERSONAL:26200
10.99.1.176.txt:JHF_PERSONAL:26196
10.99.1.186.txt:JHF_RATE_MAIL:335
10.99.1.176.txt:JHF_RATE_MAIL:332
10.99.1.186.txt:JHF_REALIZED_CASHFLOW:13079030
10.99.1.176.txt:JHF_REALIZED_CASHFLOW:13079023
10.99.1.186.txt:JHF_REPORT_ACCOUNT_INFO:1798503
10.99.1.176.txt:JHF_REPORT_ACCOUNT_INFO:1798225
10.99.1.186.txt:JHF_REPORT_ALL_CONTRACT:2586143
10.99.1.176.txt:JHF_REPORT_ALL_CONTRACT:0
10.99.1.186.txt:JHF_REPORT_ALL_CONTRACT_PROVIDER:397026
10.99.1.176.txt:JHF_REPORT_ALL_CONTRACT_PROVIDER:0
10.99.1.186.txt:JHF_REPORT_CASHFLOW_STAT:1271889
10.99.1.176.txt:JHF_REPORT_CASHFLOW_STAT:722420
10.99.1.186.txt:JHF_REPORT_CUSTOMER_LINK:734545
10.99.1.176.txt:JHF_REPORT_CUSTOMER_LINK:734440
10.99.1.186.txt:JHF_REPORT_DEPOSIT_CUSTOMER:12229
10.99.1.176.txt:JHF_REPORT_DEPOSIT_CUSTOMER:0
10.99.1.186.txt:JHF_SYS_POSITION_INSERT:7080
10.99.1.176.txt:JHF_SYS_POSITION_INSERT:6429
10.99.1.186.txt:JHF_UNREALIZED_CASHFLOW:150952
10.99.1.176.txt:JHF_UNREALIZED_CASHFLOW:149832
10.99.1.186.txt:JHF_USER_LOGIN_LOG:153596
10.99.1.176.txt:JHF_USER_LOGIN_LOG:152637
10.99.1.186.txt:JHF_WITHDRAWAL:31556
10.99.1.176.txt:JHF_WITHDRAWAL:31549




我想要这种样式,请指点:
JHF_WITHDRAWAL:   31556   31549

hualeon

cat urfile | sed 's/^.*txt://g' | sed 's/:/:[ ][ ][ ]/g'
随手写的，没试

hualeon

cat urfile | sed 's/^.*txt://g' | sed 's/:/:   /g'

hualeon

TNND
尽情的BS我吧

todayhero

原帖由 wtuter 于 2008-6-5 10:34 发表
现在如下文件:
10.99.1.186.txt:JHF_EXECUTION:6498672
10.99.1.176.txt:JHF_EXECUTION:6498488
10.99.1.186.txt:JHF_EXECUTION_BIND:6504342
10.99.1.176.txt:JHF_EXECUTION_BIND:6504314
10.99. ...

不知你要这种格式做什么.感觉我理解错了.
[root@c home]# echo `tail -2 1.txt | awk -F: '{print $2":\t"$3}' | head -1``tail -1 1.txt | awk -F: '{print $3}'`

JHF_WITHDRAWAL: 31556 31549

doctorjxd

awk 'BEGIN{FS=":"; nm="";}{ if(nm!=$2)printf("%s  %s  ",$2,$3); else  print $3; nm=$2;}'  yourfile

doctorjxd

sed  'N;s/^.*:\(.*\):\(.*\)\n.*:.*:\(.*\)/\1 \2 \3/;' yourfile

blackold

try:

1. 
   
2. awk -F: '{array[$2]=array[$2]" "$3} END { for ( i in array) print i":"array[i]}' urfile

复制代码

ly5066113

sed 'N;s/[^:]*://;s/\n.*://' urfile

awk -F: '{getline a;$0=$0":"a;print $2": "$3" "$NF}' urfile

doctorjxd

原帖由 ly5066113 于 2008-6-5 11:01 发表
sed 'N;s/[^:]*://;s/\n.*://' urfile

awk -F: '{getline a;$0=$0":"a;print $2": "$3" "$NF}' urfile

不错， 这组应该是最有效率的了。