类别

函数名称

功能描述

实例

备注

基本

运算

LowerStr("String")

把字符串全部变成小写

LowerStr("Return on Account");

="return on account"

UpperStr("String")

把字符串全部变成大写

UpperStr("msft");

= "MSFT"

LeftStr(String,sSize)

取字符串左边N位

LeftStr("Hello World",5);

= "Hello"

RightStr(String,sSize)

取字符串右边N位

RightStr("Hello World",5);

= "World"

MidStr("String",Pos,Num)

取字符串中间Num位

(从Pos位开始)

MidStr("Largest winning

trade",1,7);

= "Largest"

InStr(String1,String2)

取String2在String1中的位置。

没有则返回0

InStr("Friday is the expiration day", "Friday");

InStr("Friday is the expiration day", "Monday");

=1

=0

StrLen("String")

获取字符串长度

StrLen("Drawdown");

=8

类型

转换

Text()

转变为字符串

Text(1234);

= "1234.00"

NumToStr(Expression,Dec)

数字转为字符串

NumToStr(1500.5,3);

= "1500.500"

El_DateStr(dd, MM, yyyy)

日期转为字符串

El_DateStr(02,04,2008);

= "20080402"

StrToNum("String")

字符串转变为数字

StrToNum("2500.70");

= 2500.70

StringToDate("MM/dd/yy")

StringToDate("MM/dd/yyyy")

字符串转变为日期

StringToDate("01/01/2008");

StringToDate("04/04/99")

= 39448

= 36254

特殊字符

NewLine

换行符

FileAppend("c:\testfile.txt",

"We can see a new line"+ NewLine+"isn’t it?");

We can see a new line

isn’t it?