0
What function returns the number of occurrences of a specified character in the input string?
HankW501
The charAt function returns the number of occurrences of a specified character in the input string.
Wiki User
∙ 10y ago
Add your answer:
Earn +20 pts
What is the difference between the PMT and PPMT functions in Excel?
The PPMT function returns the amt. of interest in a specified instalment number whereas the PMT function returns the amt. of interest in every EMI payment.
A Explain the need of built-in functions in Visual Basic List out the various built in functions that are 1 Explain architecture of Distributed Database systems?
A function that is built into an application and can be accessed by end-users.A function is similar to a normal procedure but the main purpose of the function is to accept a certain input from the user and return a value which is passed on to the main program to finish the execution. There are two types of functions, the built-in functions (or internal functions) and the functions created by the programmers. he general format of a function isFunctionName (arguments) The arguments are values that are passed on to the function.Built -in function are classified under following categories * Math Functions * Conversion Functions * String Functions * Date and Time Functions * Array Functions * Misc. FunctionsMath Functions * Abs(vNumber) - Returns the absolute value of a specified number * Atn(vNumber) - Returns the arctangent of a specified number * Cos(vNumber) - Returns the cosine of a specified number (angle) * Exp(vPower) - Returns e raised to a power * Hex(vNumber) - Returns the hexadecimal value of a specified number * Int(vNumber) - Returns the integer part of a specified number * Fix(vNumber) - Returns the integer part of a specified number * Log(vNumber) - Returns the natural logarithm of a specified number * Oct(vNumber) - Returns the octal value of a specified number * Rnd() - Returns a random number less than 1 but greater or equal to 0 * Sgn(vNumber) - Returns an integer that indicates the sign of a specified number * Sin(vNumber) - Returns the sine of a specified number (angle) * Sqr(vNumber) - Returns the square root of a specified number * Tan(vNumber) - Returns the tangent of a specified number (angle) Conversion Functions * CBool(vVariant) - Converts an expression to a variant of subtype Boolean * CByte(vVariant) - Converts an expression to a variant of subtype Byte * CCur(vVariant) - Converts an expression to a variant of subtype Currency * CDate(vVariant) - Converts a valid date and time expression to the variant of subtype Date * CDbl(vVariant) - Converts an expression to a variant of subtype Double * CInt(vVariant) - Converts an expression to a variant of subtype Integer * CLng(vVariant) - Converts an expression to a variant of subtype Long * CSng(vVariant) - Converts an expression to a variant of subtype Single * CStr(vVariant) - Converts an expression to a variant of subtype StringString Functions * InStr(sString, sSubString) - Returns the position of the first occurrence of one string within another. The search begins at the first character of the string * InStrRev(sString, sSubString) - Returns the position of the first occurrence of one string within another. The search begins at the last character of the string * LCase(sString) - Converts a specified string to lowercase * Left(sString, iLen) - Returns a specified number of characters from the left side of a string * Len(sString) - Returns the number of characters in a string * LTrim(sString) - Removes spaces on the left side of a string * RTrim(sString) - Removes spaces on the right side of a string * Trim(sString) - Removes spaces on both the left and the right side of a string * Mid(sString, iStart, iLen) - Returns a specified number of characters from a string * Replace(sString, sOld, sNew) - Replaces a specified part of a string with another string a specified number of times * Right(sString) - Returns a specified number of characters from the right side of a string * Space(iLen) - Returns a string that consists of a specified number of spaces * StrComp(sString1, sString2) - Compares two strings and returns a value that represents the result of the comparison * String(iLen, sChar, iLen) - Returns a string that contains a repeating character of a specified length * StrReverse(sString) - Reverses a string * UCase(sString) - Converts a specified string to uppercase * Asc(sString) - Converts the first letter in a string to ANSI code * Chr(iInteger) - Converts the specified ANSI code to a character Date and Time Functions * CDate(vVariant) - Converts a valid date and time expression to the variant of subtype Date * Date() - Returns the current system date * DateAdd(sType, iInterval, tDate) - Returns a date to which a specified time interval has been added * DateDiff(tDate1, tDate2) - Returns the number of intervals between two dates * DatePart(sType, tDate) - Returns the specified part of a given date * DateSerial(iYear, iMonth, iDate) - Returns the date for a specified year, month, and day * DateValue(vVariant) - Returns a date * Day(tDate) - Returns a number that represents the day of the month (between 1 and 31, inclusive) * FormatDateTime(tDate, iType) - Returns an expression formatted as a date or time * Hour(tDate) - Returns a number that represents the hour of the day (between 0 and 23, inclusive) * IsDate(vVariant) - Returns a Boolean value that indicates if the evaluated expression can be converted to a date * Minute(tDate) - Returns a number that represents the minute of the hour (between 0 and 59, inclusive) * Month(tDate) - Returns a number that represents the month of the year (between 1 and 12, inclusive) * MonthName(iMonth) - Returns the name of a specified month * Now() - Returns the current system date and time * Second(tDate0 - Returns a number that represents the second of the minute (between 0 and 59, inclusive) * Time() - Returns the current system time * Timer() - Returns the number of seconds since 12:00 AM * TimeSerial(iHour, iMinute, iSecond) - Returns the time for a specific hour, minute, and second * TimeValue(tDate) Returns a time * Weekday(tDate) - Returns a number that represents the day of the week (between 1 and 7, inclusive) * WeekdayName(iWeekDay) - Returns the weekday name of a specified day of the week * Year(tDate) - Returns a number that represents the yearArray Functions * Array(vArg1, vArg2, ...) - Returns a variant containing an array * IsArray(vVariant) - Returns a Boolean value that indicates whether a specified variable is an array * Join(aArray) - Returns a string that consists of a number of substrings in an array * LBound(aArray) - Returns the smallest subscript for the indicated dimension of an array * Split(sString, sDelimiter) - Returns a zero-based, one-dimensional array that contains a specified number of substrings * UBound(aArray) - Returns the largest subscript for the indicated dimension of an arrayMisc. Functions * IsArray(variable) - Returns True if the specified variable is an array * IsDate(variable) - Returns True if the specified variable can be converted to a date * IsEmpty(variable) - Returns True if the specified variable is Empty * IsNull(variable) - Returns True is the specified variable is Null * IsNumeric(variable) - Returns True if the specified variable can be converted to a number * IsObject(variable) - Returns True if the specified variable is an object * TypeName(variable) - Returns the type name of the specified variable * VarType(vVariant) - Returns the type code of the specified variable
What is the function of pre-defined function LEN in Excel?
The LEN function returns the length of the specified string.=LEN(text)text is the string to return the length for.EXAMPLE:=LEN(word) will return the value of 4.
What is th function of the charindex?
The CHARINDEX function in SQL is used to find the position of a specific character or substring within a string. It returns the starting position of the substring or character within the given string.
What is isset in php?
isset( $var ) is a PHP function which returns TRUE or FALSE depending on whether a specified $var has been assigned to any value (or, initialized).
What is a split function?
A splint function breaks up character data into different sections. These sections are broken up with things such as space and commas. The split function then returns a specific segment.
What function returns the last but one character of end of file?
read/fread/fgetc, but beforehand you have to use lseek/llseek/fseek
A function takes the exponential function's output and returns the exponential function's input?
A __________ function takes the exponential function's output and returns the exponential function's input.
Write a function prototype named test that accepts two parameters an integer and character and returns a float?
float test(int, char);
How old is Cam Lawson in Tracy beaker returns?
In "Tracy Beaker Returns," the character Cam Lawson is portrayed as being in her late 20s to early 30s. Her exact age is not specified in the series.
What is return in programming?
The return statement is used in functions to return control to the caller. If the function is declared non-void, the return statement also allows the programmer to return a value to the caller.
What is the difference between min and max function?
The MIN function returns the lowest value from a set of values. The MAX function returns the highest value from a set of values.=MIN(A2:A20)=MAX(A2:A20)The MIN function returns the lowest value from a set of values. The MAX function returns the highest value from a set of values.=MIN(A2:A20)=MAX(A2:A20)The MIN function returns the lowest value from a set of values. The MAX function returns the highest value from a set of values.=MIN(A2:A20)=MAX(A2:A20)The MIN function returns the lowest value from a set of values. The MAX function returns the highest value from a set of values.=MIN(A2:A20)=MAX(A2:A20)The MIN function returns the lowest value from a set of values. The MAX function returns the highest value from a set of values.=MIN(A2:A20)=MAX(A2:A20)The MIN function returns the lowest value from a set of values. The MAX function returns the highest value from a set of values.=MIN(A2:A20)=MAX(A2:A20)The MIN function returns the lowest value from a set of values. The MAX function returns the highest value from a set of values.=MIN(A2:A20)=MAX(A2:A20)The MIN function returns the lowest value from a set of values. The MAX function returns the highest value from a set of values.=MIN(A2:A20)=MAX(A2:A20)The MIN function returns the lowest value from a set of values. The MAX function returns the highest value from a set of values.=MIN(A2:A20)=MAX(A2:A20)The MIN function returns the lowest value from a set of values. The MAX function returns the highest value from a set of values.=MIN(A2:A20)=MAX(A2:A20)The MIN function returns the lowest value from a set of values. The MAX function returns the highest value from a set of values.=MIN(A2:A20)=MAX(A2:A20)
