|
[广告] Excel易用宝 - 提升Excel的操作效率 · Excel / WPS表格插件 ★ 免费下载 ★ ★ 使用帮助★
'输入输出都为utf-8编码文件,,,
Option Explicit
Sub test()
Dim i, j, arr, filename, dic, t
filename = ThisWorkbook.Path & "\147654_CN.txt"
If Len(Dir(filename)) = 0 Then MsgBox filename: Exit Sub
Set dic = CreateObject("scripting.dictionary")
arr = [a1].CurrentRegion
For i = 1 To UBound(arr, 1): dic(arr(i, 1)) = arr(i, 2): Next
With CreateObject("ADODB.Stream")
.Type = 2
.Mode = 3
.Open
.LoadFromFile filename
.Charset = "UTF-8"
.Position = 2
arr = Split(Mid(.ReadText, 3), vbNewLine)
.Close
End With
For i = 0 To UBound(arr)
If IsNumeric(Left(arr(i), 1)) Then '标志位,目测是唯一的
t = Split(arr(i), Space(1))
For j = 1 To UBound(t)
If Len(t(j)) Then
If dic.exists(t(j)) Then arr(i + 1) = Space(42) & dic(t(j))
i = i + 1: Exit For
End If
Next
End If
Next
filename = Left(filename, Len(filename) - 4) & "-输出.txt"
With CreateObject("ADODB.Stream")
.Type = 2
.Mode = 3
.Charset = "utf-8"
.Open
.WriteText Join(arr, vbNewLine)
.SaveToFile filename, 2
.flush
.Close
End With
End Sub |
评分
-
1
查看全部评分
-
|