新手求助資料亂碼問題

        求助一下大神們，用什么方法能快速的把下面第一段資料處理成第二段的形式


[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

轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/92382.html

標籤：其他數據庫

上一篇：MySQL連接不能完全關閉，留下TIME_WAIT的連接

下一篇：高手幫忙看下怎么解決，無奈sql學的太爛，試了一天沒結果。