老师,上次自己研究出来一个SQL语名可以出来,但是最后太慢卡死了。
您指导的语句中有以下不明白的地方:
Dim p As String = "[a-zA-Z]+" '[^\d+] 这里是为了处理号码号中有字母的问题吗?
Dim rgx = New System.Text.RegularExpressions.Regex(p) 这个也不知道 是做什么用的,
For i As Integer = 1 To Tables("Sheet2").Rows.Count - 1
r = Tables("Sheet2").Rows(i-1)
nr = Tables("Sheet2").Rows(i)
If r("hd") = nr("hd")
a1 = r("hm")
srr = rgx.Split(a1)
n1 = srr(srr.Length - 1)
a1 = a1.Substring(0,a1.Length - n1.Length)
a2 = nr("hm")
srr = rgx.Split(a2)
n2 = srr(srr.Length - 1)
a2 = a2.Substring(0,a2.Length - n2.Length)
If a1 = a2 AndAlso CLng(n1) + 1 = CLng(n2) Then
sum+=1
Else
Output.Show(r("hd") & "," & fr & "-" & r("hm") & "," & sum) 这里新增到一个数据库表中?增加行 DataTables("表").Addnew 的方式
r = nr
fr = r("hm")
sum = 1
End If
Else
Output.Show(r("hd") & "," & fr & "-" & r("hm") & "," & sum) 为什么这里要有和上面那一段相同的代码?
r = nr
fr = r("hm")
sum = 1
End If
Next
r = nr
Output.Show(r("hd") & "," & fr & "-" & r("hm") & "," & sum)