【转】awk 里的substr函数用法举例
awk 里的substr函數用法舉例:
要截取的內容:
2007-08-04 04:45:03.084 - SuccessfulTradeResult(status: 1, currencyPair: 'USDJPY', tradeId: '17389681', clientReference: '20070803COVR00013176', tradeDateTime: '2007-08-03T19:45:02', dealerUserId: 'PANTARHEI.API1', clientName: 'PANTA RHEI SECURITIES CO LTD ', clientId: 'EU0271383', counterpartyName: 'DB', buySell: 'S', nearLeftAmount: 1810000.0, nearRightAmount: 2.138696E8, nearRate: 118.16, nearValueDate: '2007-08-07')
操作指令:
?grep -v 'errorMessage' ./GWDBCpTradeResponse.20070803 | awk -F',' '{print substr($4,20)","substr($3,12,8)","substr($2,17,6)","substr($5,18,19)","substr($9,21,2)","substr($10,12,1)","substr($11,18)","substr($12,19)","substr($13,12)","substr($14,18,10)}' | tr -d "'"
截取結果:
20070803COVR00013176,17389681,USDJPY,2007-08-3T19:45:02,DB,S,1810000.0,2.138696E8,118.16,2007-08-07
解釋:
substr($4,20)???? --->? 表示是從第4個字段里的第20個字符開始,一直到設定的分隔符","結束.
substr($3,12,8)? --->? 表示是從第3個字段里的第12個字符開始,截取8個字符結束.
?
轉自:http://yhj1065.blog.163.com/blog/static/198002172007744121626/
轉載于:https://www.cnblogs.com/nhlinkin/p/3591440.html
總結
以上是生活随笔為你收集整理的【转】awk 里的substr函数用法举例的全部內容,希望文章能夠幫你解決所遇到的問題。
- 上一篇: 安装phproject之一
- 下一篇: Hadoop学习记录(4)|MapRed