删除不应该的换行符

wmsok

[ods@ETL-2 wms]$ cat sql.log
15523:406:200;15523:13003003:-96;16001:5:600;16001:30107522:-600;16007:5:500;160
07:30107714:-500;16553:5:2000;16555:5:3000;16553:30107521:-2000;16555:30107521:-
3000;16022:13:8533;16022:30107573:-8533;16062:29:200;16062:13003003:-96;16064:35
:120;16064:12133775:-120;16150:13003003:-18708;16150:30107523:38900;16543:32:500
;16543:30107719:-500;16712:11001619:11991;16712:30107582:-11991;16809:13:6600;16
809:12141424:-5920;16809:30107571:-680;16818:13:735;16818:12021646:-91;16818:301
07573:-644;16840:13:9900;16840:12141424:-1860;16840:30107567:-1920;16840:3010757
4:-6120;16892:35:40;16892:12133775:-40;16894:35:10;16894:12133775:-10;16992:5:30
0;16992:30104566:-300;18881:32:500;18881:30107715:-500;18907:32:60;18907:3010759
5:-60;23867:0:-400;

[ods@ETL-2 wms]$ awk 'BEGIN{FS=":";RS=";"} {print $0}' sql.log
15523:406:200
15523:13003003:-96
16001:5:600
16001:30107522:-600
16007:5:500
160
07:30107714:-500
16553:5:2000
16555:5:3000
16553:30107521:-2000
16555:30107521:-
3000
16022:13:8533
16022:30107573:-8533
16062:29:200
16062:13003003:-96
16064:35
:120
16064:12133775:-120
16150:13003003:-18708
16150:30107523:38900
16543:32:500

16543:30107719:-500
16712:11001619:11991
16712:30107582:-11991
16809:13:6600
16
809:12141424:-5920
16809:30107571:-680
16818:13:735
16818:12021646:-91
16818:301
07573:-644
16840:13:9900
16840:12141424:-1860
16840:30107567:-1920
16840:3010757
4:-6120
16892:35:40
16892:12133775:-40
16894:35:10
16894:12133775:-10
16992:5:30
0
16992:30104566:-300
18881:32:500
18881:30107715:-500
18907:32:60
18907:3010759
5:-60
23867:0:-400


[ods@ETL-2 wms]$


----之前的文本换行时，从一个的数字的中间换行了，如果把实现把数字合并成一行

jason680

回复 1# wmsok

$ awk 'BEGIN{FS=":";RS=";"}{gsub(/\n/,"");print $0}' sql.log
15523:406:200
15523:13003003:-96
16001:5:600
16001:30107522:-600
16007:5:500
16007:30107714:-500
16553:5:2000
16555:5:3000
...
18907:32:60
18907:30107595:-60
23867:0:-400

wmsok

谢谢，顺便问下，以;号结尾在AWK中怎么写了？

rulebook

1. awk '{s=s$0}END{gsub(/;/,"\n",s);print s}' o

复制代码

yestreenstars

回复 3# wmsok

1. /;$/

复制代码