Welcome to
aleprojects.com

Using parser - built-in functions

General purpose methods

ToString() This method returns a string representation of the object to which it is applied.
ToString(format) This method returns a formatted string representation of the object to which it is applied. Only for objects of numeric or DateTime types. For other objects it is equal to the ToString() method. For more information about numeric format specifiers see Standard Numeric Format Strings (MSDN) and Custom Numeric Format Strings (MSDN).

Math functions

Sin(x), Cos(x), Tan(x), Sinh(x), Cosh(x), Tanh(x), Asin(x), Acos(x), Atan(x), Exp(x), Log(x), Log(10), Sqrt(x), Pow(x, y), Abs(x), Ceiling(x), Floor(x), Round(x), Truncate(x) These functions accept one parameter of type double and return exactly the same value as their .NET analogs.
Round(x, n) Rounds a double-precision floating-point value x to a specified number n of fractional digits. When n is negative, it is considered as 0, when n is greater than 15, it is considered as 15.

String functions

String(S, n) Returns a string, whose value is the first character of the S repeated n times.
Compare(S1, S2, ignoreCase) Compares two strings, ignoring or honoring their case. Function returns a positive value when S1>S2, zero value when S1=S2, negative value when S1<S2. The ignoreCase parameter is of boolean type.
Chr(code) Returns a character with specified code.
Asc(C) Returns a code of the character C .

String properties and methods

Length This property returns length of the string.
IndexOf(S) Returns position of the first occurrence of the string S within a string to which this method is applied.
IndexOf(S, n) Returns position of the first occurrence of the string S within a string to which this method is applied. The search starts at the n position.
Substring(pos) Returns a substring that starts at a specified position and continues to the end of the string.
Substring(pos, n) Returns a substring that starts at a specified position and has a specified length.
Replace(S1, S2) Returns a string in which all occurrences of the S1 are replaced by the S2.
ToUpper() Returns a string converted to uppercase.
ToLower() Returns a string converted to lowercase.
Trim() Returns a string without leading and trailing whitespaces.
TrimStart() Returns a string without leading whitespaces.
TrimEnd() Returns a string without trailing whitespaces.

Date functions

Now() Returns current date and time.
DaysInMonth(Y, M) Returns the number of days in the specified year Y and month M.
DateTime(Y, M, D, Hours, Min, Sec, Msec) Returns a datetime with the specified year, month, day, hour, minute, second, and millisecond. Hours, Min, Sec, Msec are optional parameters with default value 0.
DateTime(Ticks) Returns a datetime with the specified number of ticks.

Date properties and methods

Date, Year, Month, Day, Hour, Second, Millisecond These properties return a corresponding component from the date.
Ticks This property returns a number of ticks that represent the date and time.
Add(Y, M, D, Hours, Min, Sec, Msec) This method returns a new datetime with added datetime component. All parameters of the method are optional with default value 0.