【VB.NET】常用函数概览
写在前面的
函数的功能及其用法。Asc函数与Chr函数
Mid函数、Right函数和Left函数
Print Mid(“ABCDEFGHIJK”,2,3)
Print Mid(“ABCDEFGHIJK”,10)
Print Mid(“ABCDEFGHIJK”,2)
Print Mid(“ABCDEFGHIJK”,11)
BCD BCDEFGHIJK BCDEFGHIJK BCDEFGHIJK
Print Right (“ABCDEFGHIJK”,2)
Print Left (“ABCDEFGHIJK”,2)
KJ AB 这三个函数还存在另一个形式,即Mid
Format函数
Format(12.34)为 ”12.34”
0 Format(12.34,“0000.000”)为 “0012.340”
: Format(1,“00:”)为 “05:”,Format(12345.67,“##,###.###”)为 “12,345.67”
% Format(123.4567,“00.0%”)为 “12345.7%”(四舍五入)
@ Format(”ABcd”,“@@@@@@”)为 “Abcd”
< Format(”ABcd”,“<@@@@@@”)为 “abcd”
> Format(”ABcd”,“>@@@@@@”)为 “ABCD”
! Format(”ABcd”,“!@@@@@@”)为 “Abcd”
注意:该函数同样也有另一种形式,即Format
Replace函数Function Replace(Expression As String,Find As String,Replace As String,[Start As Long = 1],[Count As Long = -1],[Compare As VbCompareMethod = vbBinaryCompare]) As String
Replace("A1BC1DEFG","1","0") "A0BC0DEFG"
Replace("A1BC1DEFG","") "ABCDEFG"
Replace("A1BC1DEFG","0",3) "BC0DEFG"
Replace("A1BC1DEFG",1,1) "A0BC1DEFG"
Instr函数Function InStr([Start],[String1],[String2],[Compare As VbCompareMethod = vbBinaryCompare])
Space函数Function Space(Number As Long)
Filter函数Function Filter(SourceArray,Match As String,[Include As Boolean = True],[Compare As VbCompareMethod = vbBinaryCompare])
返回一个匹配字符串的数组。注意返回值是一个数组类型,其中的元素来自源数组。 IsNumeric函数Function IsNumeric(Expression) As Boolean
IsNumeric ("1A") False
IsNumeric ("&H1A") True 十六进制值
IsNumeric ("2e1") True 科学计数法
IsNumeric ("2e+1") True 指数正号可省略
IsNumeric ("2E+1") True E大小写均可
IsNumeric ("2E-1") True 指数为负
IsNumeric ("2-") True 注意负号的位置
IsNumeric ("-2") True 前后都可
IsNumeric ("2+") True 注意正号的位置
IsNumeric ("+2") True 前后都可
IsNumeric ("2+2") False
IsNumeric (".") False 小数点
IsNumeric (".1") True 小数点前的0省略
IsNumeric ("1.1") True
IsNumeric ("1.1-") True 注意负号
StrComp函数Function StrComp(String1,String2,[Compare As VbCompareMethod = vbBinaryCompare])
Split函数Function Split(Expression As String,[Delimiter],[Limit As Long = -1],[Compare As VbCompareMethod = vbBinaryCompare])
Join函数Function Join(SourceArray,[Delimiter]) As String
Dim a As String
Dim b(1) As String
b(0) = "012"
b(1) = "456"
a = Join(b(),"*")
'运行结果:a的值为
"012*456"。
String函数Function String(Number As Long,Character)
StrReverse函数Function StrReverse(Expression As String) As String
Lcase和Ucase函数Function LCase(String)
Function UCase(String)
LCase("ABCdefg文字") "abcdefg文字"
UCase("ABCdefg文字") "ABCDEFG文字"
Len函数Function Len(Expression)
Len("ABCdefg文字")结果为9。
Ltrim、Rtrim和Trim函数Function LTrim(String)
Function RTrim(String)
Function Trim(String)
写在后面的
(编辑:李大同) 【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容! |
- Postgresql允许远程访问 配置方法
- xcode – 使用其他人的开发者证书签署iOS应用程序
- SQLite for EF6 APP配置文件
- pugixml“Clone”中“xml_document”的深层副本
- FOR XML PATH 将查询结果集以XML形式展现
- PostgreSQL 权限信息表information_schema.table
- No grammar constraints (DTD or XML schema)
- ruby – 如何从Highline库中的ask方法中删除换行
- SSHF备忘之依赖包(struts2+spring2.5+hibernate+
- XML文件解析工具类pull解析