本帖最后由 思想之翼 于 2023-3-2 21:43 编辑
原题:http://www.bathome.net/viewthread.php?tid=23404&highlight=
问题:
下列VBS代码读入a.txt的数据,由于记录方式变更,产生首尾颠倒的变化,欲得到相同的运算结果,VBS代码该如何相应修改?恳望得到指点。
示例:
【a.txt 原始记录的数据】
9
0
X
Y
Z
9
0
【a.txt 首尾颠倒后的数据】
0
9
Z
Y
X
0
9- Set fso = CreateObject("Scripting.FileSystemObject")
- set file = fso.OpenTextFile("a.txt")
-
- Do Until file.AtEndOfStream
- strLine = file.ReadLine
- If strLine <> "" Then
- ReDim PreServe ar(n)
- strIn = strIn & "$" & strLine & " "
- ar(n) = strIn : n = n + 1
- End If
- Loop
-
- For i = CLng(UBound(ar)/2) to 0 step -1
- ar1 = Split(strIn,ar(i))
- If UBound(ar1) > 1 Then
- For j = 1 to UBound(ar1) - 1
- WriteToFile Split(ar1(j)),Split(ar(i))
- Next
- Exit For
- End If
- Next
-
- MsgBox "OK"
-
- Sub WriteToFile(ar2,ar3)
- If UBound(ar2) >= 1 Then
- strOut = Mid(ar2(UBound(ar2)-1),2)
- Else
- strOut = Mid(ar3(UBound(ar3)-1),2)
- End If
- fso.OpenTextFile("b.txt",8,True).WriteLine strOut
- End Sub
复制代码
|