- Foxtable(狐表) (http://foxtable.com/bbs/index.asp)
-- 专家坐堂 (http://foxtable.com/bbs/list.asp?boardid=2)
---- [求助]列类型转换问题 (http://foxtable.com/bbs/dispbbs.asp?boardid=2&id=109847)
-- 发布时间：2017/11/21 12:47:00
-- [求助]列类型转换问题
此主题相关图片如下：360截图20171121124438058.jpg
-- 发布时间：2017/11/21 14:51:00
--
方法一：新增一列【时长】，然后把【处理时长】整列的数据，拷贝粘贴过去；
方法二：参考代码
Dim t As Table = Tables("表A")
Dim d As Double
Dim str As String = "-1,"
For Each r As Row In t.rows
If r("第二列") > "" AndAlso Double.TryParse(r("第二列"), d) = False Then
str &= r("_Identify") & ","
End If
Next
t.filter = "_Identify in (" & str.trim(",") & ")"