awk 字串拼接

輸入檔案的內容

TMALL_INVENTORY_30_GROUP    my163149.cm6    3506    5683506    mysql-bin.000013 327359057TMALL_INVENTORY_31_GROUP    my163149.cm6    3606    5683606    mysql-bin.000017 301259529

$1                          $2              $3      $4         $5               $6

目標

TMALL_INVENTORY_30_GROUP       000013.327359057#5683506.0

awk

 awk  '{position=$5":"$6"#"$4; print $1, position}' posi.txt | awk -F '[.]' '{print $1,$2"."0}' | awk '{print $1,$3}'

字串拼接，使用雙引號""，來串連兩邊的字串

輸出

TMALL_INVENTORY_30_GROUP mysql-bin 000013:327359057#5683506.0TMALL_INVENTORY_31_GROUP mysql-bin 000017:301259529#5683606.0

如果輸入

awk  '{position=$5":"$6"#"$4; print $1, position}' posi.txt | awk -F '[.]' '{print $1,$2"."0}'

則輸出

TMALL_INVENTORY_30_GROUP mysql-bin 000013:327359057#5683506.0TMALL_INVENTORY_31_GROUP mysql-bin 000017:301259529#5683606.0

如果輸入

$ awk  '{position=$5":"$6"#"$4; print $1, position}' posi.txt

則輸出

TMALL_INVENTORY_30_GROUP mysql-bin.000013:327359057#5683506TMALL_INVENTORY_31_GROUP mysql-bin.000017:301259529#5683606