作者gero (憨)
看板EZsoft
標題[請問] Emeditor批次修改檔案的問題
時間Thu Jul 24 23:02:59 2008
新手剛碰
最近剛好遇到批次放入資料庫的問題
有辦法將以下資料
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
1F：→ ckw:看有沒有類似直行輸入的功能(madedit/ultraedit有) 07/24 23:13
2F：推 ckw:剛才抓來試好像預設沒有，但我google到一個plugin可做到 07/24 23:28
4F：→ yinjing:不然用取代吧 [tab] 取代成 ,[tab] 07/24 23:30
5F：→ ckw:解開到plugin底下重新執行emeditor即可，plugin>BoxEditor打勾 07/24 23:30
6F：→ hpo14:用正規表達式去取代應該很簡單吧.. @@ 07/25 18:44
7F：推 a0130520:把每行資料貼到excel 再用concatenate函數全部串起來 07/25 22:21