![]() |
#2
ictest2020-03-21 09:06
|

Private Sub Command1_Click()
Dim strWj As String
Dim strJ() As String
Dim aryContent() As Byte
Dim tmp() As String
Dim i As Long
Dim j As Long
tttt = Timer
Open "c:\1.csv" For Binary As #1
ReDim aryContent(LOF(1) - 1)
Get #1, , aryContent
Close #1
Open "c:\temp.txt" For Append As #2
strWj = StrConv(aryContent, vbUnicode)
strJ = Split(strWj, vbCrLf)
For i = 0 To UBound(strJ)
If IsNumeric(Left(strJ(i), 1)) = True Then
tmp() = Split(strJ(i), ",")
If tmp(2) = "True" Then
Print #2, tmp(5) & vbTab & tmp(6) & vbTab & tmp(16) & vbTab & tmp(20) & vbTab & tmp(23) & vbTab & tmp(24)
End If
End If
Next i
Close #2
MsgBox Timer - tttt
End Sub
Dim strWj As String
Dim strJ() As String
Dim aryContent() As Byte
Dim tmp() As String
Dim i As Long
Dim j As Long
tttt = Timer
Open "c:\1.csv" For Binary As #1
ReDim aryContent(LOF(1) - 1)
Get #1, , aryContent
Close #1
Open "c:\temp.txt" For Append As #2
strWj = StrConv(aryContent, vbUnicode)
strJ = Split(strWj, vbCrLf)
For i = 0 To UBound(strJ)
If IsNumeric(Left(strJ(i), 1)) = True Then
tmp() = Split(strJ(i), ",")
If tmp(2) = "True" Then
Print #2, tmp(5) & vbTab & tmp(6) & vbTab & tmp(16) & vbTab & tmp(20) & vbTab & tmp(23) & vbTab & tmp(24)
End If
End If
Next i
Close #2
MsgBox Timer - tttt
End Sub
只有本站会员才能查看附件,请 登录