∮冰狐√ - 2006-5-30 16:21:00
一个字符串,如 465.3MB,如何能成为数值 465.3 ??
冰马 - 2006-6-2 14:21:00
dim sString as String
sString = "11.2MB "
dim fResult as Double
dim sTemp as String
sTemp = Trim(sString)
fResult = CDbl( left(sTemp, len(sTemp)-2) ) '去掉右边的"MB", 然后转为Double类型
croci - 2006-6-2 16:35:00
replace("465.3MB","MB","")
江湖游客 - 2006-6-7 10:04:00
冰马的程序可以.但考虑到有时候后面的的字符不一定是MB,所以可以考虑直接检验字符串的ASCII是否是数字.如果是就保留.然后把获取的字符串再象冰马的代码那样转换成相应的数值就行了.具体程序参考冰马的吧.
© 2000 - 2026 Rising Corp. Ltd.