[請問] Emeditor批次修改檔案的問題

看板EZsoft (小軟體)作者 (憨)時間17年前 (2008/07/24 23:03), 編輯推噓2(205)
留言7則, 4人參與, 最新討論串1/1
新手剛碰 最近剛好遇到批次放入資料庫的問題 有辦法將以下資料 1:00:00 1 1 1 2:00:00 2 2 2 3:00:00 3 3 3 4:00:00 4 4 4 5:00:00 5 5 5 6:00:00 6 6 6 7:00:00 7 7 7 8:00:00 8 8 8 9:00:00 9 9 9 10:00:00 10 10 10 11:00:00 11 11 11 12:00:00 12 12 12 13:00:00 13 13 13 14:00:00 14 14 14 15:00:00 15 15 15 16:00:00 16 16 16 變成 1:00:00, 1, 1, 1, 2:00:00, 2, 2, 2, 3:00:00, 3, 3, 3, 4:00:00, 4, 4, 4, 5:00:00, 5, 5, 5, 6:00:00, 6, 6, 6, 7:00:00, 7, 7, 7, 8:00:00, 8, 8, 8, 9:00:00, 9, 9, 9, 10:00:00, 10, 10, 10, 11:00:00, 11, 11, 11, 12:00:00, 12, 12, 12, 13:00:00, 13, 13, 13, 14:00:00, 14, 14, 14, 15:00:00, 15, 15, 15, 16:00:00, 16, 16, 16, 並且首行加上;嗎? -- ※ 發信站: 批踢踢實業坊(ptt.cc) ◆ From: 125.231.47.14

07/24 23:13, , 1F
看有沒有類似直行輸入的功能(madedit/ultraedit有)
07/24 23:13, 1F

07/24 23:28, , 2F
剛才抓來試好像預設沒有,但我google到一個plugin可做到
07/24 23:28, 2F

07/24 23:28, , 3F
07/24 23:28, 3F

07/24 23:30, , 4F
不然用取代吧 [tab] 取代成 ,[tab]
07/24 23:30, 4F

07/24 23:30, , 5F
解開到plugin底下重新執行emeditor即可,plugin>BoxEditor打勾
07/24 23:30, 5F

07/25 18:44, , 6F
用正規表達式去取代應該很簡單吧.. @@
07/25 18:44, 6F

07/25 22:21, , 7F
把每行資料貼到excel 再用concatenate函數全部串起來
07/25 22:21, 7F
文章代碼(AID): #18Y9cbqc (EZsoft)
文章代碼(AID): #18Y9cbqc (EZsoft)