returns an expression converted to a date in the format determined xDate: the expression that contains the date xDateFormat: the date format (if Null or = "" the default is "dd/MM/yyyy") Return type: @return:the date
CDbl (xValueAsObject) AsDouble
returns a value converted to a double xValue: the value to be converted Return type: @return:the value converted to a double
Chr (xNumberAsInt) AsString
returns a character equivalent to the numeric code specified (ASCII) xNumber: the numeric code Return type: @return:the equivalent character
CInt (xValueAsObject) AsInt
returns a value converted to a integer xValue: the value to be converted Return type: @return:the value converted to a integer
CLng (xValueAsObject) AsLong
returns a value converted to a long xValue: the value to be converted Return type: @return:the value converted to a long
CStr (xValueAsObject) AsString
returns a value converted to a string xValue: the value to be converted Return type: @return:the value converted to a string
DegreesToRadians (xDegreesAsDouble) AsDouble
returns the value in radians from degrees
HexToBinary (xHexValueAsString) AsString
converts an hex string to a binary string xHexValue: the hex string to be converted Return type: @return:the binary string
HexToInteger (xHexValueAsString) AsInt
converts an hex string to a integer value xHexValue: the hex string to be converted Return type: @return:the integer value
HexToLong (xHexValueAsString) AsLong
converts an hex string to a long value xHexValue: the hex string to be converted Return type: @return:the long value
Int (xExpressionAsObject) AsInt
returns an expression converted to a integer xExpression: the expression to be converted Return type: @return:the expression converted to a integer
IntegerToHex (xValueAsInt) AsString
converts an integer value to a hex string xValue: the number to be converted Return type: @return:the hex string
LongToHex (xValueAsLong) AsString
converts an long value to a hex string xValue: the number to be converted Return type: @return:the hex string
RadiansToDegrees (xRadiansAsDouble) AsDouble
returns the value in degrees from radians
Val (xExpressionAsObject) AsObject
returns a numeric value xExpression: a numeric expression Return type: @return:the numeric value
returns the number of working days between two dates xStartDate: the start date xEndDate: the end date xMode: 0 = normal, 1 = keep holidays, 2 = keep weekends, 3 = keep holidays and weekends
returns a value corresponding to the number of time intervals between two dates xDate1: the date 1 xDate2: the date 2 xInterval: "y" = years, "m" = months, "d" days, "h" = hours, "n" = minutes, "s" = seconds, "!" = milliseconds xAbsoluteValue: 'true' = absolute value, 'false' = none
returns the date found of the previous weekday xWeekday: the day of week (1 = sunday, 2 = monday, ..., 7 = saturday) xDate: the date from which to search
FirstDateOfCurrentWeekAsjava.util.Date
returns the date of the first day of the current week
returns the date subsequent to the weekday setted for the number of recurrences specified xDate: the start date xNth: the number of recurrences xWeekday: the weekday (1 = sunday, 2 = monday, ..., 7 = saturday) xMode: [false] = starts from the day specified in the date, [true] = starts from the first day of the month shown in the date
returns the datestring on which have added days xDatestring: the datestring to which should be added the days xDays: the number of days to add to the datestring
returns the datestring on which have added months xDatestring: the datestring to which should be added the months xMonths: the number of months to add to the datestring
returns the datestring on which have added years xDatestring: the datestring to which should be added the years xYears: the number of years to add to the datestring
returns the number of working days between two datestring xStartDatestring: the start datestring xEndDatestring: the end datestring xMode: 0 = normal, 1 = keep holidays, 2 = keep weekends, 3 = keep holidays and weekends
returns a value corresponding to the number of time intervals between two datestring xDatestring1: the datestring 1 xDatestring2: the datestring 2 xInterval: "y" = years, "m" = months, "d" days, "h" = hours, "n" = minutes, "s" = seconds, "!" = milliseconds xAbsoluteValue: 'true' = absolute value, 'false' = none
returns the datestring found of the next weekday xWeekday: the day of week (1 = sunday, 2 = monday, ..., 7 = saturday) xDatestring: the datestring from which to search
returns the datestring found of the previous weekday xWeekday: the day of week (1 = sunday, 2 = monday, ..., 7 = saturday) xDatestring: the datestring from which to search
FirstDategOfWeek (xDatestringAsString) AsString
returns the datestring of the first day of the week
FirstDateOfCurrentWeekAsString
returns the datestring of the first day of the current week
FirstDateOfMonth (xDatestringAsString) AsString
returns the datestring of the first day of the month
FirstDateOfQuarter (xDatestringAsString) AsString
returns the datestring corresponding to the first day of a quarter
returns the name of the first workday of the month xDatestring: the start datestring xMode: = 0 skip holidays, = 1 skip weekends, = 2 skip holidays and weekends
returns the datestring of the first workday of the month xDatestring: the start datestring xMode: = 0 skip holidays, = 1 skip weekends, = 2 skip holidays and weekends
GetDateFormatAsString
returns the datestring format in use (default is "dd/MM/yyyy")
GetFirstWeekdayAsInt
returns the first weekday (1 = sunday *default*, 2 = monday, ..., 7 = saturday)
GetHolidaysAsString()
returns an string array containing all holidays allocated in memory
returns the name of the last workday of the month xDatestring: the start datestring xMode: = 0 skip holidays, = 1 skip weekends, = 2 skip holidays and weekends
returns the datestring of the last workday of the month xDatestring: the start datestring xMode: = 0 skip holidays, = 1 skip weekends, = 2 skip holidays and weekends
returns the datestring of the next workday xDatestring: the start datestring xMode: = 0 skip holidays, = 1 skip weekends, = 2 skip holidays and weekends
returns the datestring subsequent to the weekday setted for the number of recurrences specified xDatestring: the start datestring xNth: the number of recurrences xWeekday: the weekday (1 = sunday, 2 = monday, ..., 7 = saturday) xMode: [false] = starts from the day specified in the datestring, [true] = starts from the first day of the month shown in the datestring
PreviousDate (xDatestringAsString) AsString
returns the previous datestring (24 hours before), 'Null' is datestring not valid or error
returns the boolean value assigned to the specific section and key SectionName: the section name KeyName: the key name Return type: @return:the boolean value
returns the date value assigned to the specific section and key SectionName: the section name KeyName: the key name Return type: @return:the date value
returns the double value assigned to the specific section and key SectionName: the section name KeyName: the key name Return type: @return:the double value
returns the integer value assigned to the specific section and key SectionName: the section name KeyName: the key name Return type: @return:the integer value
rdKeyNames (SectionNameAsString) AsString()
returns a string array containing the names of all the keys under specified section SectionName: the name of the section for which names of properties is to be retrieved Return type: @return:the string array of key names
rdKeys (SectionNameAsString) Asjava.util.Map
returns a map containing all the keys under specified section SectionName: the name of the section for which properties are to be retrieved Return type: @return:the map of properties
returns the long value assigned to the specific section and key SectionName: the section name KeyName: the key name Return type: @return:the long value
rdNumberSectionsAsInt
returns the number of sections in INI file Return type: @return:the total number of sections
returns the named section or null if named section does not exists SectionName: the section name to be searched Return type: @return:the named section or null if named section does not exists
rdSectionNamesAsString()
returns a string array containing the names of all sections in INI file Return type: @return:the string array of section names
returns the string value assigned to the specific section and key SectionName: the section name KeyName: the key name Return type: @return:the string value
returns the timestamp value assigned to the specific section and key SectionName: the section name KeyName: the key name Return type: @return:the timestamp value
rmKey (SectionNameAsString, KeyNameAsString)
remove the specified key from the specified section SectionName: the section name KeyName: the key name
rmSection (SectionNameAsString)
remove the specified section SectionName: the section name
SetDateFormat (DateFormatAsString)
set the date format DateFormat: the format string, if date format is not valid assumes by default "yyyy-MM-dd"
SetFileName (FileNameAsString)
set the INI file to use FileName: the full path and name of the INI file
SetTimestampFormat (TimestampFormatAsString)
set the timestamp format TimestampFormat: the format string, if timestamp format is not valid assumes by default "yyyy-MM-dd"
UpDateAsBoolean
update the INI file, if the INI file does not exist it is created
write the boolean value to the specific section and key SectionName: the section name KeyName: the key name booleanValue: the boolean value Comments: the comments
write the date value to the specific section and key SectionName: the section name KeyName: the key name DateValue: the date value Comments: the comments
write the double value to the specific section and key SectionName: the section name KeyName: the key name DoubleValue: the double value Comments: the comments
write the integer value to the specific section and key SectionName: the section name KeyName: the key name IntegerValue: the integer value Comments: the comments
write the long value to the specific section and key SectionName: the section name KeyName: the key name LongValue: the long value Comments: the comments
write the string value to the specific section and key SectionName: the section name KeyName: the key name StringValue: the string value Comments: the comments
write the timestamp value to the specific section and key SectionName: the section name KeyName: the key name TimestampValue: the timestamp value Comments: the comments
calculating the italian fiscal code (codice fiscale italiano) xFirstName: the firs tname xLastName: the last name xBirthDate: the birth date ("dd/mm/yyyy") xBirthTownCode: the birth town code (locality code or country code for italian fiscal agency) xSex: the sex (F = female, M = male) Return type: @return:the italian fiscal code
check the italian fiscal code (codice fiscale italiano) xItalianFiscalCode: the italian fiscal code to be verified Return type: @return:the verification of fiscal code (0 = OK, 1 = length 0, 2 = incorrect length, 3 = illegal character, 4 = control code not match)
CheckItalianVATID (xVATIDAsString) AsInt
check the italian VAT ID (partita IVA italiana) xVATID: the VAT ID to be verified Return type: @return:the verification of VAT ID (0 = OK, 1 = length 0, 2 = incorrect length, 3 = illegal character, 4 = control code not match)
returns the distance between two points identified by geographic coordinates xLatitude1: the latitude of point 1 xLongitude1: the longitude of point 1 xLatitude2: the latitude of point 2 xLongitude2: the longitude of point 2 xMeasureUnit: the unit measure (0 = Km, 1 = Miles) xAlgorithmType: the type of algorithm used for the distance calculation (1 = haversine, 2 = spherical law of cosines, 3 = spherical earth projection) Return type: @return:the computed distance
IsPrime (xNumberAsLong) AsBoolean
returns [true] if the value if it is a prime number, otherwise [false]
Log (xValueAsDouble) AsDouble
returns the natural logarithm of a numeric value xValue: the numeric expression
MCD (xAsLong, yAsLong) AsLong
returns the greatest common divisor relative to two numeric values
MCM (xAsLong, yAsLong) AsLong
returns the least common multiple relative to two numeric values
Mod (xValue1AsDouble, xValue2AsDouble) AsDouble
returns returns the remainder of a division xValue1: the number value to be divided xValue2: the number value of the divisor
PIAsDouble
PI constant
RndAsDouble
returns a random double value with a positive sign
Rnd2 (xValueAsDouble) AsDouble
returns a random double value with a positive sign xValue: the numeric value that represents the "base"
Round (xValueAsDouble) AsDouble
returns a number rounded xValue: the numeric expression being rounded
returns a number rounded to decimals specified xValue: the numeric expression being rounded xDigitsAfterDecimal: the digits to the right of the decimal are included in the rounding
Sec (xValueAsDouble) AsDouble
returns the secant of a numeric value xValue: the numeric expression
Sech (xValueAsDouble) AsDouble
returns the hyperbolicsecant of a numeric value xValue: the numeric expression
Sgn (xValueAsDouble) AsInt
returns an integer indicating the sign of a numeric value xValue: the numeric expression Return type: @return:-1 = less than zero, 0 = equal to zero, 1 = greater than zero
ShLint (xValueAsInt, xShiftAsInt) AsInt
shifts the bits of value shift-bits to the left xValue: the value to be shifted xShift: the amount of bits to shift the bits of value
ShLlng (xValueAsLong, xShiftAsInt) AsLong
shifts the bits of value shift-bits to the left xValue: the value to be shifted xShift: the amount of bits to shift the bits of value
ShRint (xValueAsInt, xShiftAsInt) AsInt
shifts the bits of value shift-bits to the right and keeps the MSB xValue: the value to be shifted xShift: the amount of bits to shift the bits of value
ShRlng (xValueAsLong, xShiftAsInt) AsLong
shifts the bits of value shift-bits to the right and keeps the MSB xValue: the value to be shifted xShift: the amount of bits to shift the bits of value
ShRZint (xValueAsInt, xShiftAsInt) AsInt
shifts the bits of value shift-bits to the right and shifts also the MSB xValue: the value to be shifted xShift: the amount of bits to shift the bits of value
ShRZlng (xValueAsLong, xShiftAsInt) AsLong
shifts the bits of value shift-bits to the right and shifts also the MSB xValue: the value to be shifted xShift: the amount of bits to shift the bits of value
Sin (xValueAsDouble) AsDouble
returns the sine of an angle xValue: the value that expresses an angle in radian
SinC (xValueAsDouble) AsDouble
returns the sine cardinale of a numeric value xValue: the numeric expression
Sinh (xValueAsDouble) AsDouble
returns the hyperbolicsine of a numeric value xValue: the numeric expression
Sqr (xValueAsDouble) AsDouble
returns the square root of a numeric value xValue: the numeric expression
Tan (xValueAsDouble) AsDouble
returns the tangent of an angle xValue: the numeric expression that expresses an angle in radians
Tanh (xValueAsDouble) AsDouble
returns the hyperbolictangent of a numeric value xValue: the numeric expression
checks the equality between two strings (case sensitive) xString1: the string to verify xString2: the verification string Return type: @return:[true] is equals, [false] not equals
checks the equality between two strings ignoring upper and lower case xString1: the string to verify xString2: the verification string Return type: @return:[true] is equals, [false] not equals
InStr (xString1AsString, xString2AsString) AsInt
returns the position of the first occurrence of a string within another xString1: the string where to search xString2: the string to find Return type: @return:the position of the string found (0 = not found)
returns the position of the first occurrence of a string within another, starting from a predetermined position xStart: the starting position within the string search xString1: the string where to search xString2: the string to find Return type: @return:the position of the string found (0 = not found)
returns the position of the first occurrence of a string within another, starting from a predetermined position and with comparison method xStart: the starting position within the string search xString1: the string where to search xString2: the string to find xCompareMethod: the comparison method (0 = binary, 1 = text) Return type: @return:the position of the string found (0 = not found)
returns the position of an occurrence of a string included in another from the end of the string xString1: the string where to search xString2: the string to find Return type: @return:the position of the string found (0 = not found)
returns the position of an occurrence of a string included in another from the end of the string, starting from a predetermined position xString1: the string where to search xString2: the string to find xStart: the starting position within the string search Return type: @return:the position of the string found (0 = not found)
returns the position of an occurrence of a string included in another from the end of the string, starting from a predetermined position and with comparison method xString1: the string where to search xString2: the string to find xStart: the starting position within the string search xCompareMethod: the comparison method (0 = binary, 1 = text) Return type: @return:the position of the string found (0 = not found)
IsBlank (xStringAsString) AsBoolean
checks if a string is blank xString: the string to verify Return type: @return:[true] is blank, [false] is not blank
IsEmpty (xStringAsString) AsBoolean
checks if a string is empty xString: the string to verify Return type: @return:[true] is empty, [false] is not empty
IsNotBlank (xStringAsString) AsBoolean
checks if a string is not blank xString: the string to verify Return type: @return:[true] is not blank, [false] is blank
IsNotEmpty (xStringAsString) AsBoolean
checks if a string is not empty xString: the string to verify Return type: @return:[true] is not empty, [false] is empty
checks if a character at a given position is a whitespace xString: the string to verify xIndex: the character position within the string Return type: @return:[true] is a whitespace, [false] is not a whitespace
LCase (xStringAsString) AsString
returns a string converted to lower case xString: the string to be converted Return type: @return:the string in lower case
Len (xStringAsString) AsInt
returns the length of a string xString: the string Return type: @return:the length of string
LTrim (xStringAsString) AsString
removes whitespace to left xString: the string to be trimmed Return type: @return:the trimmed result
MD5 (xStringAsString) AsString
returns the MD5 hash of a string xString: the string in input Return type: @return:the string processed
returns a portion of a string xString: the string in input xStart: the position where to start to take the characters the: number of characters to be taken Return type: @return:the portion of the string
Mid2 (String1AsString, StartAsInt) AsString
returns a portion of a string xString: the string in input xStart: the position where to start to take the characters until to reach the end of the string Return type: @return:the portion of the string
returns a string in which a specified substring has been replaced with another substring xString: the string in input xFind: the substring to find xReplacement: the replacement substring Return type: @return:the modified string
returns a string of the same character repeated n times xNumber: the number of times to repeat xCharacter: the character to repeat Return type: @return:the string of repeats
RTrim (xStringAsString) AsString
removes whitespace to right xString: the string to be trimmed Return type: @return:the trimmed result
SHA1 (xStringAsString) AsString
returns a string processed with SHA1 algorithm xString: the string in input Return type: @return:the string processed
Space (xNumberAsInt) AsString
returns a string of whitespace repeated n times xNumber: the number of whitespace to repeat Return type: @return:the string of whitespace
returns an array of substrings extracted from a string where the data were separated by a delimiter xString: the string containing delimited data xDelimiter: the delimiter Return type: @return:the array of the substrings extracted
compares two strings xString1: the string to be compared xString2: the string used for comparison xMethod: the comparison type (0 = binary, 1 = text) Return type: @return:-1 = xString1 < xString2, 0 = the two strings are equal, 1 = xString1 > xString2
returns a string of the same character repeated n times xNumber: the number of times to repeat xCharacter: the character to repeat Return type: @return:the string of repeats
returns a string adjusted as required xString: the string in input xOutputLength: the length of string in output xAdjustmentType: the type of adjustment (0 = left, 1 = right, 2 = middle, 3 = all trim, >3 = none) xFillCharacter: the fill character Return type: @return:the string modified
StringToByteArray (xStringAsString) AsByte()
returns a array of bytes from a string xString: the string in input Return type: @return:the array of bytes
StripAccents (xStringAsString) AsString
returns a string without accents (eg. "sarà" -> "sara") xString: the string in input Return type: @return:the string modified
StrReverse (xStringAsString) AsString
returns a string in which the character order of the specified string is reversed xString: the string in input Return type: @return:the reversed string
Trim (xStringAsString) AsString
removes leading and trailing whitespace xString: the string to be trimmed Return type: @return:the trimmed result
UCase (xStringAsString) AsString
returns a string converted to upper case xString: the string to be converted Return type: @return:the string in upper case
returns a timestring which is the sum of two timestring xTimestring1: "xHH:MM:SS" (eg. "252:03:08") xTimestring2: "xHH:MM:SS" (eg. "03:06:52") xNrDigitsHour: the number of digits for displaying the hours field
returns a value corresponding to the number of time intervals between two datetimestring xDateTimestring1: the datatimestring 1 xDateTimestring2: the datatimestring 2 xInterval: "y" = years, "m" = months, "d" days, "h" = hours, "n" = minutes, "s" = seconds, "!" = milliseconds xAbsoluteValue: 'true' = absolute value, 'false' = none
GetTimestampFormatAsString
returns the timestamp format in use (default is "dd/MM/yyyy hh:mm:ss")
returns a timestring of the specified hours xHours: the hours to be converted xNrDigitsHour: the number of digits for displaying the hours field xDigitsMinutes: = [true] the minutes field is included, otherwise nothing xDigitsSeconds: = [true] the seconds field is included, otherwise nothing
returns a timestring of the specified minutes xMinutes: the minutes to be converted xNrDigitsHour: the number of digits for displaying the hours field xDigitsSeconds: = [true] the seconds field is included, otherwise nothing
returns the timestring normalized ("xHH:MM:SS") xTimestring: the timestring to be normalized xNrDigitsHour: the number of digits for displaying the hours field
SecondsToMinutes (xSecondsAsLong) AsLong()
returns an array of two elements (minutes and the rest of seconds)
returns a timestring which is the difference (subtraction) between two timestring xTimestring1: "xHH:MM:SS" (eg. "256:00:00") xTimestring2: "xHH:MM:SS" (eg. "252:03:08") xNrDigitsHour: the number of digits for displaying the hours field
returns the hours from a timestring xTimestring1: "xHH:MM:SS" (eg. "13:31:27") xRoundMinutes: increment of one hour if >= of the timestring minutes, the minutes are set to 0 xRoundSeconds: increment of one minute if >= of the timestring seconds, the seconds are set to 0
returns the minutes from a timestring xTimestring1: "xHH:MM:SS" (eg. "08:25:43") xRoundSeconds: increment of one minute if >= of the timestring seconds, the seconds are set to 0