新手求问处理log日志文件乱码问题

xuer666 2018-07-26 09:03:43
求助一下大神们,怎样快速的把下面第一段数据处理成第二段的形式,谢谢!
需要达到的目的:1.当氨气、氧气、硫化氢、粉尘、二氧化碳、温度、湿度和光强这8组文字和数据都齐全时保留该行数据,否则删除
2.当一行中出现两个分机时,应保留一个
3.删除数据中的乱码

【第一段数据】
[2018-02-14 01:10:23]分机2,氨气,000,氧气,21.8,硫化氢,000,粉尘,000,二氧化碳,0398,温度,15.4,湿度,40.2,光强,0000
[2018-02-14 01:11:00]分机3,分机4,氨气,071,氧气,17.1,硫化氢,095,粉尘,000,二氧化碳,0397,温度,14.8,湿度,49.2,光强,0000
[2018-02-14 01:11:20]分机5,氨气,074,氧气,17.6,硫化氢,084,粉尘,000,二氧化碳,0404,温度,15.2,湿度,34.9,光强,0000
[2018-02-14 01:11:46]分机6,氨气,070,氧气,19.5,硫化氢,119,粉尘,000,二氧化碳,0418,温度,15.8,湿度,44.0,光强,0000
[2018-02-14 01:12:02]分机7,氨气,015,氧气,20.8,硫化氢,003,粉尘,000,二氧化碳,0393,温度,15.2,湿度,36.4,光强,0000
[2018-02-14 01:12:25]分机8,氨气,071,氧气,18.9,硫化氢,113,粉尘,000,二氧化碳,0431,温度,15.2,湿度,40.7,光强,0000
[2018-02-14 01:12:42]分机9,氨气,072,氧气,20.1,硫化氢,121,粉尘,051,二氧化碳,0418,温度,15.3,湿度,47.3,光强,0000
[2018-02-14 01:13:19]分机10,分机1,氨气,000,氧气,23.0,硫化氢,002,粉尘,000,二氧化碳,0443,温度,14.5,湿度,37.2,光强,0010
[2018-02-14 01:13:43]分机2,氨气,001,氧气,22.2,硫化氢,001,粉尘,000,二氧化碳,0398,温度,15.4,湿度,40.0,光强,0000
[2018-02-14 01:14:20]分机3,分机4,氨气,067,氧气,17.0,硫化氢,116,粉尘,000,二氧化碳,0398,温度,14.9,湿度,51.1,光强,0000
[2018-02-14 01:14:40]分机5,氨气,063,氧气,19.0,硫化氢,101,粉尘,000,二氧化碳,0411,温度,15.4,湿度,35.9,光强,0000
[2018-02-14 01:15:22]分机6,分机7,氨气,071,氧气,19.5,硫化氢,118,粉尘,000,二氧化碳,0479,温度,15.9,湿度,47.5,光强,0000
[2018-02-14 01:15:45]分机8,氨气,072,氧气,19.9,硫化氢,105,粉尘,000,二氧化碳,0515,温度,15.4,湿度,44.3,光强,0000
[2018-02-14 01:16:02]分机9,氨气,074,氧气,20.2,硫化氢,118,粉尘,054,二氧化碳,0473,温度,15.5,湿度,52.2,光强,0000
[2018-02-14 01:16:39]分机10,分机1,氨气,003,氧气,23.1,硫化氢,000,粉尘,000,二氧化碳,0576,温度,14.9,湿度,40.6,光强,0010
[2018-02-14 01:17:03]分机2,氨气,000,氧气,22.0,硫化氢,000,粉尘,000,二氧化碳,0562,温度,15.7,湿度,43.4,光强,0000
[2018-02-14 01:17:40]分机3,分机4,氨气,070,氧气,17.0,硫化氢,104,粉尘,000,二氧化碳,0564,温度,15.3,湿度,53.9,光强,0000
[2018-02-14 01:18:00]分机5,氨气,065,氧气,19.0,硫化氢,101,粉尘,000,二氧化碳,0618,温度,15.9,湿度,38.5,光强,0000
[2018-02-14 01:18:26]分机6,氨气,073,氧气,19.6,硫化氢,117,粉尘,000,二氧化碳,0607,温度,16.3,湿度,45.6,光强,0000
[2018-02-14 01:18:43]分机7,氨气,016,氧气,20.7,硫化氢,003,粉尘,000,二氧化碳,0556,温度,15.8,湿度,39.5,光强,0000
[2018-02-14 01:19:16]d9(#|j.{攦巕|帆堥3r:j圖华H"瑲鵝饬I斻[梜V覾蔲j剤-讄gD鴷A盄搳5',羕恴5甹姛匮v蔬禁轃分机8,分机9,氨气,069,氧气,19.0,硫化氢,116,粉尘,000,二氧化碳,0654,温度,15.8,湿度,43.0,光强,0000
[2018-02-14 01:19:59]分机10,分机1,氨气,000,氧气,21.4,硫化氢,001,粉尘,000,二氧化碳,0624,温度,15.4,湿度,39.3,光强,0010
[2018-02-14 01:20:23]分机2,氨气,000,氧气,22.1,硫化氢,000,粉尘,000,二氧化碳,0594,温度,16.2,湿度,41.4,光强,0000
[2018-02-14 01:21:00]分机3,分机4,氨气,060,氧气,20.2,硫化氢,101,粉尘,000,二氧化碳,0587,温度,15.7,湿度,49.2,光强,0000
[2018-02-14 01:21:20]分机5,氨气,061,氧气,19.8,硫化氢,123,粉尘,000,二氧化碳,0609,温度,16.3,湿度,36.7,光强,0000
[2018-02-14 01:21:46]分机6,氨气,071,氧气,19.3,硫化氢,121,粉尘,000,二氧化碳,0586,温度,16.8,湿度,42.2,光强,0000
[2018-02-14 01:22:03]分机7,氨气,016,氧气,20.8,硫化氢,003,粉尘,000,二氧化碳,0530,温度,16.2,湿度,37.3,光强,0000
[2018-02-14 01:22:25]分机8,氨气,070,氧气,19.3,硫化氢,117,粉尘,000,二氧化碳,0659,温度,16.2,湿度,41.8,光强,0000
[2018-02-14 01:22:42]分机9,氨气,075,氧气,19.7,硫化氢,118,粉尘,053,二氧化碳,0608,温度,16.2,湿度,47.5,光强,0000
[2018-02-14 01:23:19]分机10,分机1,氨气,001,氧气,21.7,硫化氢,002,粉尘,000,二氧化碳,0656,温度,15.7,湿度,37.0,光强,0010
[2018-02-14 01:23:43]分机2,氨气,000,氧气,22.0,硫化氢,000,粉尘,000,二氧化碳,0624,温度,16.5,湿度,40.4,光强,0000
[2018-02-14 01:24:20]分机3,分机4,氨气,062,氧气,19.1,硫化氢,099,粉尘,000,二氧化碳,0612,温度,15.9,湿度,48.2,光强,0000
[2018-02-14 01:24:41]分机5,氨气,074,氧气,17.7,硫化氢,102,粉尘,000,二氧化碳,0626,温度,16.6,湿度,35.5,光强,0000
[2018-02-14 01:25:06]分机6,氨气,071,氧气,19.6,硫化氢,118,粉尘,000,二氧化碳,0579,温度,17.0,湿度,41.2,光强,0000
[2018-02-14 01:25:17]分机7,蟱杪LJ夋纅F_$w塐pP蘱p筢QJ
[2018-02-14 01:25:17] 鱀羱GJIs鉅F褷JVV'b檮#駈攩橐!晠/=n[樝羐桳"爼f#虶d#爅爅匮v蔬禁轃烘趋踪锄邁藌鬟nyy镙過[鏪课趨掘唧蒥燂牺x祷服啕亏?醢逼015,氧气,20.8,硫化氢,002,粉尘,000,二氧化碳,0542,温度,16.4,湿度,36.7,光强,0000
[2018-02-14 01:26:01]分机8,分机9,氨气,072,氧气,18.9,硫化氢,115,粉尘,000,二氧化碳,0679,温度,16.3,湿度,41.5,光强,0000
[2018-02-14 01:26:39]分机10,分机1,氨气,000,氧气,21.7,硫化氢,003,粉尘,000,二氧化碳,0651,温度,16.0,湿度,36.5,光强,0010
[2018-02-14 01:27:03]分机2,氨气,000,氧气,21.8,硫化氢,000,粉尘,000,二氧化碳,0620,温度,16.7,湿度,39.6,光强,0000
[2018-02-14 01:27:56]分机3,分机4,氨气,062,氧气,17.0,硫化氢,124,粉尘,000,二氧化碳,0587,温度,16.1,湿度,47.9,分机5,氨气,072,氧气,18.5,硫化氢,086,粉尘,000,二氧化碳,0610,温度,16.7,湿度,35.8,光强,0000
[2018-02-14 01:28:06]光强,0000
[2018-02-14 01:28:26]分机6,氨气,070,氧气,19.5,硫化氢,118,粉尘,000,二氧化碳,0588,温度,17.1,湿度,41.4,光强,0000
[2018-02-14 01:28:43]分机7,氨气,016,氧气,20.8,硫化氢,002,粉尘,000,二氧化碳,0532,温度,16.5,湿度,36.4,光强,0000
[2018-02-14 01:29:05]分机8,氨气,075,氧气,18.9,硫化氢,111,粉尘,000,二氧化碳,0652,温度,16.4,湿度,41.0,光强,0000
[2018-02-14 01:29:22]分机9,氨气,072,氧气,20.2,硫化氢,119,粉尘,049,二氧化碳,0591,温度,16.6,湿度,47.2,光强,0000
[2018-02-14 01:29:59]分机10,分机1,氨气,001,氧气,21.9,硫化氢,001,粉尘,000,二氧化碳,0646,温度,16.1,湿度,36.5,光强,0010
[2018-02-14 01:31:16]分机2,分机3,分机4,氨气,063,氧气,18.1,硫化氢,117,粉尘,000,二氧化碳,0595,温度,16.1,湿度,47.8,光强,0分机5,氨气,064,氧气,20.4,硫化氢,107,粉尘,000,二氧化碳,0592,温度,16.7,湿度,35.6,光强,0000
[2018-02-14 01:31:31]000
[2018-02-14 01:32:02]分机6,分机7,氨气,071,氧气,19.8,硫化氢,117,粉尘,000,二氧化碳,0582,温度,17.1,湿度,41.2,光强,0000
[2018-02-14 01:32:25]分机8,氨气,071,氧气,20.4,硫化氢,107,粉尘,000,二氧化碳,0650,温度,16.4,湿度,41.1,光强,0000
[2018-02-14 01:32:42]分机9,氨气,074,氧气,20.2,硫化氢,117,粉尘,046,二氧化碳,0593,温度,16.6,湿度,47.2,光强,0000




【第二段数据】
[2018-02-14 01:10:23]分机2,氨气,000,氧气,21.8,硫化氢,000,粉尘,000,二氧化碳,0398,温度,15.4,湿度,40.2,光强,0000
[2018-02-14 01:11:00]分机4,氨气,071,氧气,17.1,硫化氢,095,粉尘,000,二氧化碳,0397,温度,14.8,湿度,49.2,光强,0000
[2018-02-14 01:11:20]分机5,氨气,074,氧气,17.6,硫化氢,084,粉尘,000,二氧化碳,0404,温度,15.2,湿度,34.9,光强,0000
[2018-02-14 01:11:46]分机6,氨气,070,氧气,19.5,硫化氢,119,粉尘,000,二氧化碳,0418,温度,15.8,湿度,44.0,光强,0000
[2018-02-14 01:12:02]分机7,氨气,015,氧气,20.8,硫化氢,003,粉尘,000,二氧化碳,0393,温度,15.2,湿度,36.4,光强,0000
[2018-02-14 01:12:25]分机8,氨气,071,氧气,18.9,硫化氢,113,粉尘,000,二氧化碳,0431,温度,15.2,湿度,40.7,光强,0000
[2018-02-14 01:12:42]分机9,氨气,072,氧气,20.1,硫化氢,121,粉尘,051,二氧化碳,0418,温度,15.3,湿度,47.3,光强,0000
[2018-02-14 01:13:19]分机1,氨气,000,氧气,23.0,硫化氢,002,粉尘,000,二氧化碳,0443,温度,14.5,湿度,37.2,光强,0010
[2018-02-14 01:13:43]分机2,氨气,001,氧气,22.2,硫化氢,001,粉尘,000,二氧化碳,0398,温度,15.4,湿度,40.0,光强,0000
[2018-02-14 01:14:20]分机4,氨气,067,氧气,17.0,硫化氢,116,粉尘,000,二氧化碳,0398,温度,14.9,湿度,51.1,光强,0000
[2018-02-14 01:14:40]分机5,氨气,063,氧气,19.0,硫化氢,101,粉尘,000,二氧化碳,0411,温度,15.4,湿度,35.9,光强,0000
[2018-02-14 01:15:22]分机7,氨气,071,氧气,19.5,硫化氢,118,粉尘,000,二氧化碳,0479,温度,15.9,湿度,47.5,光强,0000
[2018-02-14 01:15:45]分机8,氨气,072,氧气,19.9,硫化氢,105,粉尘,000,二氧化碳,0515,温度,15.4,湿度,44.3,光强,0000
[2018-02-14 01:16:02]分机9,氨气,074,氧气,20.2,硫化氢,118,粉尘,054,二氧化碳,0473,温度,15.5,湿度,52.2,光强,0000
[2018-02-14 01:16:39]分机1,氨气,003,氧气,23.1,硫化氢,000,粉尘,000,二氧化碳,0576,温度,14.9,湿度,40.6,光强,0010
[2018-02-14 01:17:03]分机2,氨气,000,氧气,22.0,硫化氢,000,粉尘,000,二氧化碳,0562,温度,15.7,湿度,43.4,光强,0000
[2018-02-14 01:17:40]分机4,氨气,070,氧气,17.0,硫化氢,104,粉尘,000,二氧化碳,0564,温度,15.3,湿度,53.9,光强,0000
[2018-02-14 01:18:00]分机5,氨气,065,氧气,19.0,硫化氢,101,粉尘,000,二氧化碳,0618,温度,15.9,湿度,38.5,光强,0000
[2018-02-14 01:18:26]分机6,氨气,073,氧气,19.6,硫化氢,117,粉尘,000,二氧化碳,0607,温度,16.3,湿度,45.6,光强,0000
[2018-02-14 01:18:43]分机7,氨气,016,氧气,20.7,硫化氢,003,粉尘,000,二氧化碳,0556,温度,15.8,湿度,39.5,光强,0000
[2018-02-14 01:19:16]分机9,氨气,069,氧气,19.0,硫化氢,116,粉尘,000,二氧化碳,0654,温度,15.8,湿度,43.0,光强,0000
[2018-02-14 01:19:59]分机1,氨气,000,氧气,21.4,硫化氢,001,粉尘,000,二氧化碳,0624,温度,15.4,湿度,39.3,光强,0010
[2018-02-14 01:20:23]分机2,氨气,000,氧气,22.1,硫化氢,000,粉尘,000,二氧化碳,0594,温度,16.2,湿度,41.4,光强,0000
[2018-02-14 01:21:00]分机4,氨气,060,氧气,20.2,硫化氢,101,粉尘,000,二氧化碳,0587,温度,15.7,湿度,49.2,光强,0000
[2018-02-14 01:21:20]分机5,氨气,061,氧气,19.8,硫化氢,123,粉尘,000,二氧化碳,0609,温度,16.3,湿度,36.7,光强,0000
[2018-02-14 01:21:46]分机6,氨气,071,氧气,19.3,硫化氢,121,粉尘,000,二氧化碳,0586,温度,16.8,湿度,42.2,光强,0000
[2018-02-14 01:22:03]分机7,氨气,016,氧气,20.8,硫化氢,003,粉尘,000,二氧化碳,0530,温度,16.2,湿度,37.3,光强,0000
[2018-02-14 01:22:25]分机8,氨气,070,氧气,19.3,硫化氢,117,粉尘,000,二氧化碳,0659,温度,16.2,湿度,41.8,光强,0000
[2018-02-14 01:22:42]分机9,氨气,075,氧气,19.7,硫化氢,118,粉尘,053,二氧化碳,0608,温度,16.2,湿度,47.5,光强,0000
[2018-02-14 01:23:19]分机1,氨气,001,氧气,21.7,硫化氢,002,粉尘,000,二氧化碳,0656,温度,15.7,湿度,37.0,光强,0010
[2018-02-14 01:23:43]分机2,氨气,000,氧气,22.0,硫化氢,000,粉尘,000,二氧化碳,0624,温度,16.5,湿度,40.4,光强,0000
[2018-02-14 01:24:20]分机4,氨气,062,氧气,19.1,硫化氢,099,粉尘,000,二氧化碳,0612,温度,15.9,湿度,48.2,光强,0000
[2018-02-14 01:24:41]分机5,氨气,074,氧气,17.7,硫化氢,102,粉尘,000,二氧化碳,0626,温度,16.6,湿度,35.5,光强,0000
[2018-02-14 01:25:06]分机6,氨气,071,氧气,19.6,硫化氢,118,粉尘,000,二氧化碳,0579,温度,17.0,湿度,41.2,光强,0000
[2018-02-14 01:26:01]分机9,氨气,072,氧气,18.9,硫化氢,115,粉尘,000,二氧化碳,0679,温度,16.3,湿度,41.5,光强,0000
[2018-02-14 01:26:39]分机1,氨气,000,氧气,21.7,硫化氢,003,粉尘,000,二氧化碳,0651,温度,16.0,湿度,36.5,光强,0010
[2018-02-14 01:27:03]分机2,氨气,000,氧气,21.8,硫化氢,000,粉尘,000,二氧化碳,0620,温度,16.7,湿度,39.6,光强,0000
[2018-02-14 01:27:56]分机4,氨气,062,氧气,17.0,硫化氢,124,粉尘,000,二氧化碳,0587,温度,16.1,湿度,47.9,光强,0000
[2018-02-14 01:28:06]分机5,氨气,072,氧气,18.5,硫化氢,086,粉尘,000,二氧化碳,0610,温度,16.7,湿度,35.8,光强,0000
[2018-02-14 01:28:26]分机6,氨气,070,氧气,19.5,硫化氢,118,粉尘,000,二氧化碳,0588,温度,17.1,湿度,41.4,光强,0000
[2018-02-14 01:28:43]分机7,氨气,016,氧气,20.8,硫化氢,002,粉尘,000,二氧化碳,0532,温度,16.5,湿度,36.4,光强,0000
[2018-02-14 01:29:05]分机8,氨气,075,氧气,18.9,硫化氢,111,粉尘,000,二氧化碳,0652,温度,16.4,湿度,41.0,光强,0000
[2018-02-14 01:29:22]分机9,氨气,072,氧气,20.2,硫化氢,119,粉尘,049,二氧化碳,0591,温度,16.6,湿度,47.2,光强,0000
[2018-02-14 01:29:59]分机1,氨气,001,氧气,21.9,硫化氢,001,粉尘,000,二氧化碳,0646,温度,16.1,湿度,36.5,光强,0010
[2018-02-14 01:31:16]分机4,氨气,063,氧气,18.1,硫化氢,117,粉尘,000,二氧化碳,0595,温度,16.1,湿度,47.8,光强,0000
[2018-02-14 01:31:31]分机5,氨气,064,氧气,20.4,硫化氢,107,粉尘,000,二氧化碳,0592,温度,16.7,湿度,35.6,光强,0000
[2018-02-14 01:32:02]分机7,氨气,071,氧气,19.8,硫化氢,117,粉尘,000,二氧化碳,0582,温度,17.1,湿度,41.2,光强,0000
[2018-02-14 01:32:25]分机8,氨气,071,氧气,20.4,硫化氢,107,粉尘,000,二氧化碳,0650,温度,16.4,湿度,41.1,光强,0000
[2018-02-14 01:32:42]分机9,氨气,074,氧气,20.2,硫化氢,117,粉尘,046,二氧化碳,0593,温度,16.6,湿度,47.2,光强,0000
...全文
568 回复 打赏 收藏 转发到动态 举报
写回复
用AI写文章
回复
切换为时间正序
请发表友善的回复…
发表回复

27,579

社区成员

发帖
与我相关
我的任务
社区描述
MS-SQL Server 应用实例
社区管理员
  • 应用实例社区
加入社区
  • 近7日
  • 近30日
  • 至今
社区公告
暂无公告

试试用AI创作助手写篇文章吧