|
Option Explicit
Sub test()
Dim ar, br, i&, j&, strTxt$, strFileName$, strPath$
Application.ScreenUpdating = False
strPath = ThisWorkbook.Path & "\"
br = [{23,20.2024030037259;24,387;25,5024.8}]
With CreateObject("VBScript.RegExp")
.Pattern = ">([\d+\.]+)?<"
strFileName = Dir(strPath & "*.b5r")
Do Until strFileName = ""
strTxt = ReadFromTextFile(ThisWorkbook.Path & "\" & strFileName)
ar = Split(strTxt, vbLf)
For j = 1 To UBound(br)
ar(br(j, 1)) = .Replace(ar(br(j, 1)), ">" & br(j, 2) & "<")
Next j
WriteToTextFile strPath & strFileName, Join(ar, vbCrLf)
strFileName = Dir
Loop
End With
Application.ScreenUpdating = True
Beep
End Sub
Function ReadFromTextFile$(ByVal strFullName$, _
Optional ByVal strCharSet$ = "UTF-8")
With CreateObject("ADODB.Stream")
.Type = 2
.Mode = 3
.Charset = strCharSet
.Open
.LoadFromFile strFullName
ReadFromTextFile = .ReadText
.Close
End With
End Function
Function WriteToTextFile(ByVal strFullName$, _
ByVal strTxt$, Optional ByVal strCharSet$ = "UTF-8")
With CreateObject("ADODB.Stream")
.Type = 2
.Mode = 3
.Charset = strCharSet
.Open
.WriteText strTxt
.SaveToFile strFullName, 2
.flush
.Close
End With
End Function
|
评分
-
2
查看全部评分
-
|