awk处理关联文件有关问题

tp_settle_rule|end_date|
tp_settle_rule_temporary|start_date|
tp_settle_rule_temporary|end_date|
settle_catalog_array_temp|deal_date|
tp_hcode_static_bak|start_date|
tp_hcode_static_bak|end_date|

tabnum.txt内容如下：
alarm|0
flux_monitor_instance|110
flux_monitor_task|2
life_cycle|0
operator|3
product_def|118
product_offer|0
s_country_imsi|0
settle_catalog_array_temp|0
settle_catalog_array_temporary|56264
table_operation_log|1930985
td_a_month|121
td_placard|0
tg_task|15
tp_163_config|0
tp_card_rate_part|0
tp_ctry|249
tp_discount|91
tp_discount_temporary|91
tp_dz_hcode|0
tp_gaoe_def|338
tp_hcode|197690
tp_hcode_bak|174781
tp_hcode_static_bak|193013
tp_hcode_temporary|193013
tp_icp_rule|0
tp_iden_call_happen_area|0
tp_iden_office|53277
tp_iden_office_temporary|53277
tp_iden_office_temporary_bak|53162
tp_iden_settle_logic|9
tp_inter_tsp_gaoe|0
tp_local_ratio|40
tp_local_ratio_temporary|40
tp_monitor_val_manager|0
tp_mss_report_import|176
tp_national_800|16
tp_one_year|365
tp_phone_brand|280
tp_phone_brand_temporary|280
tp_roam_msc|0
tp_settle_cycle|336
tp_settle_fee_gjj|1545
tp_settle_rule|128
tp_settle_rule_temporary|128
tp_special_phone|247
tp_special_phone_temporary|247
tp_stt_object|585
tp_toll_ratio|34
tp_toll_ratio_temporary|34
tp_trunk|1010
tp_trunk_temporary|1010
tpi_iden_settle_type|26
tpi_rate_cell|3
tpj_iden_rate|8464
tpz_iden_settle_type|0
tpz_rate_cell|0
vp_trunk_in|887
vp_trunk_out|897
vpi_settle_type|26
web_report|552
work_log|2912
我想实现tabnum.txt第二个字段不为0时，输出tabclums.txt中的$1,$2的值。怎么用awk实现？
我写了如下语句关联不出来
awk -F\| 'NR==FNR {a[$1]+=$2} NR>FNR&&a[$1]>0 {print $1,$2}' tabnum.txt abclums.txt
请高手解答：顺便请给我讲讲awk的关联方法

[解决办法]
cat data.dat | awk -F"|" '{if($2 ！= 0) print $1, $2}'
[解决办法]
个人感觉这样最直观
$paste -d"|" tabnum.txt abcclums.txt | awk -F"|" '{if ($2 != 0) print $3, $4}'
还有很多办法的
[解决办法]
只用awk的话可以这样
awk -F"|" '{tmp=$2; getline <abcclums.txt;if (tmp == "0") print $1,$2}' tabnum.txt
[解决办法]
哦，不好意思，是搞错了，弄成了0时输出.改变如下：

Perl code

[Hsxzhe--16:58:36 awk]$:cat awk.file1BEGIN{    FS="|"}(FILENAME==ARGV[1]){arry1[NR]=$1;arry2[NR]=$2}(FILENAME==ARGV[2] && $2!=0){print arry1[FNR],arry2[FNR]}[Hsxzhe--16:58:44 awk]$:awk -f awk.file1 tabclums.txt tabnum.txttp_monitor_val_manager end_datesettle_catalog_array_temporary start_datetp_hcode_bak end_datetable_operation_log deal_datetimetp_discount_temporary end_timetp_discount_temporary start_datetp_discount_temporary end_datetp_discount start_timetp_discount end_datetp_dz_hcode start_datetimetp_dz_hcode end_datetimetp_card_rate_part end_datetp_iden_office start_datetp_iden_office end_datetp_iden_call_happen_area start_datetp_iden_call_happen_area end_datetp_iden_settle_logic adjust_timetp_iden_office_temporary start_datetp_iden_office_temporary end_datetp_hcode_temporary start_datetp_hcode start_datetp_hcode end_datetp_gaoe_def end_datetimetpz_iden_settle_type start_datetimetpz_iden_settle_type end_datetimetpz_rate_cell start_datetimetpz_rate_cell end_datetimetp_163_config validate_rule2tp_special_phone_temporary start_datetp_special_phone_temporary end_datetp_special_phone start_datetp_special_phone end_datetp_toll_ratio_temporary start_datetp_toll_ratio_temporary end_datetp_toll_ratio start_datetp_toll_ratio end_datework_log log_timeweb_report create_datetp_trunk_temporary start_datetp_trunk_temporary end_datetp_trunk start_datetp_settle_fee_gjj end_datetp_one_year one_datetp_phone_brand start_datetp_phone_brand end_datetp_phone_brand_temporary start_date[Hsxzhe--16:58:52 awk]$:

awk处理关联文件有关问题

热点推荐