Left(<string>,<number>) Returns the leftmost specified number of characters from a specified string.
|
<string> - The character string
<number> - The number of characters to be returned
Example: Left(ProjectAA,7) - Returns "Project"
|
Right(<string>,<number>) Returns the rightmost specified number of characters from a specified string.
|
<string> - The character string
<number> - The number of characters to be returned
Example: Returns "AA" Right(ProjectAA,2) -
|
Mid(<string>,<startpos>,<number>) Returns a substring from a specified string (starting at a specified position).
|
<string> - The
character string<startpos> - The number of the starting position. The first
character is position 0.
<number> - The number of characters to be returned
Example: Mid(ProjectAA,2,2) -
Returns "oj"
|
Length(<string>) Returns the length of a specified string.
|
<string> Example: Length(ProjectAA) - Returns 9
|
Reverse(<string>) Returns the reverse of a specified string.
|
<string> Example: Reverse(stockholm) - Returns "mlohkcots"
|
Find(<string>,<substring>) Searches a specified string for the first match of a character or substring. Returns the position where the character or substring is found. The first position in the character string is 0.
|
<string> - The character string<substring> - The character substring for which to search
Example: Find(abc,b) - Returns 1
|
ReverseFind(<string>,<substring>) Searches a specified string for the last match of a character. Returns the position where the last occurrence of the character or substring is found. The first position in the character string is 0.
|
<string> - The character string<substring> - The character substring for which to search
Example: ReverseFind(abcabc,b) - Returns 4
|
CurrentTime(%%Y-%%m-%%d %%H:%%M:%%S) Returns the current date or time in a specified format.
|
%%a - Abbreviated weekday name %%A - Full weekday name
%%b - Abbreviated month name
%%B - Full month name
%%c - Date and time representation appropriate for locale
%%d - Day of month as decimal number (01 - 31)
%%H - Hour in 24-hour format (00 - 23)
%%I - Hour in 12-hour format (01 - 12)
%%j - Day of year as decimal number (001 - 366)
%%m - Month as decimal number (01 - 12)
%%M - Minutes as decimal number (00 - 59)
%%p - Current locale's A.M./P.M. indicator for 12-hour clock
|
|
%%S - Seconds as decimal number (00 - 59)
%%U - Week of year as decimal number, with Sunday as first day of week (00 - 53)
%%w - Weekday as decimal number (0 - 6; Sunday is 0)
%%W - Week of year as decimal number, with Monday as first day of week (00 - 53)
%%x - Date representation for current locale
%%X - Time representation for current locale
%%y - Year without century, as decimal number (00 - 99)
%%Y - Year with century, as decimal number
%%z,%%Z - Either the time zone name or abbreviation, depending on registry settings; no characters if time zone is unknown
%%%% - Percent sign
Examples: CurrentTime(%%y%%m%%d) - Returns "050113" CurrentTime (%%H:%%M) - Returns "09:53"
|