[root@test-apache yuhj]# cat c.txt
INSERT INTO TABLES VALUES
('0');
INSERT INTO TABLES VALUES
('1');
INSERT INTO TABLES VALUES
('2');
INSERT INTO
TABLES VALUES
('3');
INSERT INTO TABLES VALUES
('4');
[root@test-apache yuhj]# awk 'BEGIN{RS=";";ORS=";\n"}NR<6{print$1,$2,$3,$4,$5}' c.txt
INSERT INTO TABLES VALUES ('0');
INSERT INTO TABLES VALUES ('1');
INSERT INTO TABLES VALUES ('2');
INSERT INTO TABLES VALUES ('3');
INSERT INTO TABLES VALUES ('4');
[root@test-apache yuhj]# awk 'BEGIN{RS=";";ORS=";\n"}$1=$1' c.txt
INSERT INTO TABLES VALUES ('0');
INSERT INTO TABLES VALUES ('1');
INSERT INTO TABLES VALUES ('2');
INSERT INTO TABLES VALUES ('3');
INSERT INTO TABLES VALUES ('4');
评论