Home
Search
Tell a Friend
ABS() Array() ASC() CHR() CInt() CStr() Date() DateAdd() DateDiff() DatePart() DateSerial() DateValue() Day() Fix() FormatCurrency() FormatDateTime() FormatNumber() FormatPercent() Hour() InStr() InStrRev() Int() IsArray() IsDate() IsEmpty() IsNull() IsNumeric() IsObject() Join() LBound() LCase() Left() Len() LTrim() Mid() Minute() Month() MonthName() Now() Replace() RGB() Right() Rnd() Round() RTrim() Second() Space() Split() Sqr() strComp() String() StrReverse() Time() TimeSerial() TimeValue() TypeName() UBound() UCase() VarType() WeekDay() WeekDayName() Year()
|
Split() Purpose:Returns a zero-based, one-dimensional array containing a specified number of substrings. DataType:Array Syntax:Split(string [, delimiter[, count[, compare]]]) Arguments:"string" is any valid string;
"delimiter" (optional) is the string character to be used to identify the substring; if missing, space is used.
"count" (optional) is the number of substring to be returned. -1 is default which indicates all;
"compare" (op Sample: arrNew = Split("White, Yellow, Blue, Red", ",") Result: [obtained an array (arrNew) contains 4 elements] Date Added: 1/9/2001
|