Difference between revisions of "SUN Report Builder/Functions"
From Apache OpenOffice Wiki
Line 1: | Line 1: | ||
{{Database/Lang|Base/Reports/Functions}} | {{Database/Lang|Base/Reports/Functions}} | ||
− | + | '''Date/Time'''<br> | |
− | |||
− | |||
− | |||
− | |||
{| class="prettytable" cellpadding="10" border="1" | {| class="prettytable" cellpadding="10" border="1" | ||
| '''''Function Name''''' | | '''''Function Name''''' | ||
Line 12: | Line 8: | ||
|- | |- | ||
− | | | + | | DATE |
− | | | + | | Provides an internal number for the date given. |
+ | {| class="prettytable" cellpadding="10" border="1" | ||
+ | | '''''Parameter Name''''' | ||
+ | | '''''Parameter Description''''' | ||
+ | |||
+ | |- | ||
+ | | month | ||
+ | | An integer between 1 and 12 representing the month. | ||
+ | |- | ||
+ | | day | ||
+ | | An integer between 1 and 31 representing the day of the month. | ||
+ | |} | ||
+ | |||
| | | | ||
+ | |||
+ | |- | ||
+ | | DATEDIF | ||
+ | | Returns the number of years, months, or days between two dates. | ||
+ | {| class="prettytable" cellpadding="10" border="1" | ||
+ | | '''''Parameter Name''''' | ||
+ | | '''''Parameter Description''''' | ||
+ | |||
+ | |- | ||
+ | | EndDate | ||
+ | | Second date. | ||
+ | |- | ||
+ | | Format | ||
+ | | Format code. | ||
|} | |} | ||
− | + | | | |
+ | |||
+ | |- | ||
+ | | DATEVALUE | ||
+ | | Returns an internal number for a text having a possible date format. | ||
+ | | | ||
+ | |||
+ | |- | ||
+ | | DAY | ||
+ | | Returns the sequential date of the month as an integer (1-31) in relation to the date value. | ||
+ | | | ||
+ | |- | ||
+ | | DAYS | ||
+ | | Calculates the number of days between two dates. | ||
{| class="prettytable" cellpadding="10" border="1" | {| class="prettytable" cellpadding="10" border="1" | ||
− | | ''''' | + | | '''''Parameter Name''''' |
− | | '''''Description''''' | + | | '''''Parameter Description''''' |
− | | | + | |
+ | |- | ||
+ | | Date_1 | ||
+ | | The start date for calculating the difference in days. | ||
+ | |} | ||
+ | |||
+ | | | ||
+ | |||
+ | |- | ||
+ | | HOUR | ||
+ | | Determines the sequential number of the hour of the day (0-23) for the time value. | ||
+ | | | ||
+ | |||
+ | |- | ||
+ | | MINUTE | ||
+ | | Determines the sequential number for the minute of the hour (0-59) for the time value. | ||
+ | | | ||
+ | |||
+ | |- | ||
+ | | MONTH | ||
+ | | Determines the sequential number of a month of the year (1-12) for the date value. | ||
+ | | | ||
+ | |||
+ | |- | ||
+ | | NOW | ||
+ | | Determines the current time of the computer. | ||
+ | | | ||
|- | |- | ||
− | | | + | | SECOND |
− | | | + | | Determines the sequential number of the second of a minute (0-59) for the time value. |
| | | | ||
|- | |- | ||
− | | | + | | TIME |
− | | | + | | Determines a time value from the details for hour, minute and second. |
+ | {| class="prettytable" cellpadding="10" border="1" | ||
+ | | '''''Parameter Name''''' | ||
+ | | '''''Parameter Description''''' | ||
+ | |||
+ | |- | ||
+ | | minute | ||
+ | | The integer for the minute. | ||
+ | |- | ||
+ | | second | ||
+ | | The integer for the second. | ||
+ | |} | ||
+ | |||
| | | | ||
|- | |- | ||
− | | | + | | TIMEVALUE |
− | | | + | | Returns a sequential number for a text shown in a possible time entry format. |
| | | | ||
|- | |- | ||
− | | | + | | TODAY |
− | | | + | | Determines the current date of the computer. |
| | | | ||
|- | |- | ||
− | | | + | | WEEKDAY |
− | | | + | | Returns the day of the week for the date value as an integer (1-7). |
+ | {| class="prettytable" cellpadding="10" border="1" | ||
+ | | '''''Parameter Name''''' | ||
+ | | '''''Parameter Description''''' | ||
+ | |||
+ | |- | ||
+ | | Type | ||
+ | | Fixes the beginning of the week and the type of calculation to be used.(1 = Sunday is the first day of the week, with value 1; Saturday has value 7, 2 = Monday is the first day of the week, with value 1; Sunday has value 7, 3 = Monday is the first day of the week, with value 0; Sunday has value 6) | ||
+ | |} | ||
+ | |||
| | | | ||
|- | |- | ||
− | | | + | | YEAR |
− | | | + | | Returns the year of a date value as an integer. |
| | | | ||
+ | |} | ||
+ | <br> | ||
+ | '''Mathematical'''<br> | ||
+ | {| class="prettytable" cellpadding="10" border="1" | ||
+ | | '''''Function Name''''' | ||
+ | | '''''Description''''' | ||
+ | | '''''Example ''''' | ||
|- | |- | ||
− | | | + | | ABS |
− | | | + | | Absolute value of a number. |
| | | | ||
|- | |- | ||
− | | | + | | AVERAGE |
− | | | + | | Returns the average of a sample. |
| | | | ||
|- | |- | ||
− | | | + | | AVERAGE |
− | | | + | | Returns the average of a sample. |
| | | | ||
|- | |- | ||
− | | | + | | EVEN |
− | | | + | | Rounds a positive number up and negative number down to the nearest even integer. |
| | | | ||
|- | |- | ||
− | | | + | | MAX |
− | | | + | | Returns the maximum value in a list of arguments. |
| | | | ||
|- | |- | ||
− | | | + | | MAXA |
− | | | + | | Returns the maximum value in a list of arguments. Text is evaluated as zero. |
| | | | ||
|- | |- | ||
− | | | + | | MIN |
− | | | + | | Returns the minimum value in a list of arguments. |
| | | | ||
|- | |- | ||
− | | | + | | MINA |
− | | Returns the | + | | Returns the smallest value in a list of arguments. Text is evaluated as zero. |
| | | | ||
+ | |||
+ | |- | ||
+ | | MOD | ||
+ | | Calculates the remainder of a division. | ||
+ | {| class="prettytable" cellpadding="10" border="1" | ||
+ | | '''''Parameter Name''''' | ||
+ | | '''''Parameter Description''''' | ||
+ | |||
+ | |- | ||
+ | | Divisor | ||
+ | | The number by which the dividend is divided. | ||
|} | |} | ||
− | + | | | |
+ | |||
+ | |- | ||
+ | | ODD | ||
+ | | Rounds a positive number up and negative number down to the nearest odd integer. | ||
+ | | | ||
+ | |- | ||
+ | | SUM | ||
+ | | Returns the sum of all arguments. | ||
+ | | | ||
+ | |} | ||
+ | <br> | ||
+ | '''Logical'''<br> | ||
{| class="prettytable" cellpadding="10" border="1" | {| class="prettytable" cellpadding="10" border="1" | ||
| '''''Function Name''''' | | '''''Function Name''''' | ||
Line 103: | Line 215: | ||
|- | |- | ||
− | | | + | | AND |
− | | Returns the | + | | Returns TRUE if all arguments are TRUE. |
+ | | | ||
+ | |||
+ | |- | ||
+ | | FALSE | ||
+ | | Defines the logical value as FALSE. | ||
+ | | | ||
+ | |||
+ | |- | ||
+ | | IF | ||
+ | | Specifies a logical test to be performed. | ||
{| class="prettytable" cellpadding="10" border="1" | {| class="prettytable" cellpadding="10" border="1" | ||
| '''''Parameter Name''''' | | '''''Parameter Name''''' | ||
Line 110: | Line 232: | ||
|- | |- | ||
− | | | + | | Then_value |
− | | | + | | The result of the function if the logical test returns a TRUE. |
|- | |- | ||
− | | | + | | Otherwise_value |
− | | | + | | The result of the function if the logical test returns FALSE. |
|} | |} | ||
Line 120: | Line 242: | ||
|- | |- | ||
− | | | + | | NOT |
− | | Returns the number of | + | | Reverses the value of the argument. |
+ | | | ||
+ | |||
+ | |- | ||
+ | | OR | ||
+ | | Returns TRUE if an argument is TRUE. | ||
+ | | | ||
+ | |||
+ | |- | ||
+ | | TRUE | ||
+ | | Returns the logical value TRUE. | ||
+ | | | ||
+ | |||
+ | |- | ||
+ | | XOR | ||
+ | | Returns TRUE if a odd number of arguments are TRUE. | ||
+ | | | ||
+ | |} | ||
+ | <br> | ||
+ | '''Information'''<br> | ||
+ | {| class="prettytable" cellpadding="10" border="1" | ||
+ | | '''''Function Name''''' | ||
+ | | '''''Description''''' | ||
+ | | '''''Example ''''' | ||
+ | |||
+ | |- | ||
+ | | CHOOSE | ||
+ | | Selects a value from a list of up to 30 value arguments. | ||
{| class="prettytable" cellpadding="10" border="1" | {| class="prettytable" cellpadding="10" border="1" | ||
| '''''Parameter Name''''' | | '''''Parameter Name''''' | ||
Line 127: | Line 276: | ||
|- | |- | ||
− | | | + | | value |
− | | | + | | Value 1, value 2,... The list of arguments from which a value is chosen. |
+ | |} | ||
+ | |||
+ | | | ||
+ | |||
|- | |- | ||
− | | | + | | COUNT |
− | | | + | | Counts how many numbers are in the list of arguments. |
+ | | | ||
+ | |||
|- | |- | ||
− | | | + | | COUNTA |
− | | | + | | Counts how many values are in the list of arguments. |
− | | | + | | |
+ | |- | ||
+ | | COUNTBLANK | ||
+ | | Counts the blank cells in a specified range. | ||
| | | | ||
|- | |- | ||
− | | | + | | HASCHANGED |
− | | | + | | Checks whether the columns specified by the given names has changed. |
| | | | ||
|- | |- | ||
− | | | + | | ISBLANK |
− | | Returns | + | | Returns TRUE if value refers to an empty cell. |
| | | | ||
|- | |- | ||
− | | | + | | ISERR |
− | | Returns the | + | | Returns TRUE if the value is an error value not equal to #N/A. |
| | | | ||
|- | |- | ||
− | | | + | | ISERROR |
− | | Returns the | + | | Returns TRUE if the value is an error value. |
| | | | ||
|- | |- | ||
− | | | + | | ISEVEN |
− | | Returns | + | | Returns TRUE if value is an even integer. |
| | | | ||
|- | |- | ||
− | | | + | | ISLOGICAL |
− | | Returns the | + | | Returns TRUE if the value carries a logical number format. |
− | + | | | |
− | |||
− | |||
|- | |- | ||
− | | | + | | ISNA |
− | | | + | | Returns TRUE if value equals #N/A. |
+ | | | ||
+ | |||
|- | |- | ||
− | | | + | | ISNONTEXT |
− | | | + | | Returns TRUE if the value is not text. |
− | | | + | | |
+ | |- | ||
+ | | ISNUMBER | ||
+ | | Returns TRUE if value is a number. | ||
| | | | ||
|- | |- | ||
− | | | + | | ISODD |
− | | Returns | + | | Returns TRUE if value is an odd integer. |
− | | | + | | |
|- | |- | ||
− | | | + | | ISREF |
− | | Returns | + | | Returns TRUE if value is a reference. |
− | + | | | |
− | |||
− | |||
|- | |- | ||
− | | | + | | ISTEXT |
− | | | + | | Returns TRUE if value is text. |
− | | | + | | |
+ | |- | ||
+ | | NA | ||
+ | | Not available. Returns the error value #N/A. | ||
| | | | ||
+ | |} | ||
+ | <br> | ||
+ | '''User-Defined'''<br> | ||
+ | {| class="prettytable" cellpadding="10" border="1" | ||
+ | | '''''Function Name''''' | ||
+ | | '''''Description''''' | ||
+ | | '''''Example ''''' | ||
|- | |- | ||
− | | | + | | NULL |
− | | Returns | + | | Returns a NULL-Value |
| | | | ||
|} | |} | ||
− | + | <br> | |
− | + | '''Text'''<br> | |
{| class="prettytable" cellpadding="10" border="1" | {| class="prettytable" cellpadding="10" border="1" | ||
| '''''Function Name''''' | | '''''Function Name''''' | ||
Line 214: | Line 383: | ||
|- | |- | ||
| EXACT | | EXACT | ||
− | | | + | | Specifies whether two texts are identical. |
{| class="prettytable" cellpadding="10" border="1" | {| class="prettytable" cellpadding="10" border="1" | ||
| '''''Parameter Name''''' | | '''''Parameter Name''''' | ||
Line 220: | Line 389: | ||
|- | |- | ||
− | | | + | | text_2 |
− | | The second text. | + | | The second text for comparing texts. |
|} | |} | ||
Line 228: | Line 397: | ||
|- | |- | ||
| FIND | | FIND | ||
− | | | + | | Looks for a string of text within another (case sensitive) |
{| class="prettytable" cellpadding="10" border="1" | {| class="prettytable" cellpadding="10" border="1" | ||
| '''''Parameter Name''''' | | '''''Parameter Name''''' | ||
Line 234: | Line 403: | ||
|- | |- | ||
− | | | + | | text |
− | | The text | + | | The text in which a search is to be made. |
|- | |- | ||
− | | | + | | position |
− | | The | + | | The position in the text from which the search starts. |
|} | |} | ||
Line 245: | Line 414: | ||
|- | |- | ||
| LEFT | | LEFT | ||
− | | Returns a | + | | Returns the first character or characters of a text. |
{| class="prettytable" cellpadding="10" border="1" | {| class="prettytable" cellpadding="10" border="1" | ||
| '''''Parameter Name''''' | | '''''Parameter Name''''' | ||
Line 251: | Line 420: | ||
|- | |- | ||
− | | | + | | number |
− | | The | + | | The number of characters for the start text. |
|} | |} | ||
Line 259: | Line 428: | ||
|- | |- | ||
| LEN | | LEN | ||
− | | | + | | Calculates length of a text string. |
| | | | ||
|- | |- | ||
| LOWER | | LOWER | ||
− | | | + | | Converts text to lowercase. |
| | | | ||
|- | |- | ||
| MID | | MID | ||
− | | Returns | + | | Returns a partial text string of a text. |
{| class="prettytable" cellpadding="10" border="1" | {| class="prettytable" cellpadding="10" border="1" | ||
| '''''Parameter Name''''' | | '''''Parameter Name''''' | ||
Line 275: | Line 444: | ||
|- | |- | ||
− | | | + | | start |
− | | The | + | | The position from which the part word is to be determined. |
|- | |- | ||
− | | | + | | number |
− | | The | + | | The number of characters for the text. |
|} | |} | ||
Line 286: | Line 455: | ||
|- | |- | ||
| REPLACE | | REPLACE | ||
− | | | + | | Replaces characters within a text string with a different text string. |
{| class="prettytable" cellpadding="10" border="1" | {| class="prettytable" cellpadding="10" border="1" | ||
| '''''Parameter Name''''' | | '''''Parameter Name''''' | ||
Line 292: | Line 461: | ||
|- | |- | ||
− | | | + | | position |
− | | The | + | | The character position from which text is to be replaced. |
|- | |- | ||
− | | | + | | length |
− | | The | + | | The number of characters to be replaced. |
|- | |- | ||
− | | | + | | new text |
− | | The | + | | The text to be inserted. |
|} | |} | ||
Line 306: | Line 475: | ||
|- | |- | ||
| REPT | | REPT | ||
− | | | + | | Repeats text a given number of times. |
{| class="prettytable" cellpadding="10" border="1" | {| class="prettytable" cellpadding="10" border="1" | ||
| '''''Parameter Name''''' | | '''''Parameter Name''''' | ||
Line 312: | Line 481: | ||
|- | |- | ||
− | | | + | | number |
− | | The | + | | The number of times the text is to be repeated. |
|} | |} | ||
Line 320: | Line 489: | ||
|- | |- | ||
| RIGHT | | RIGHT | ||
− | | Returns a | + | | Returns the last character or characters of a text. |
{| class="prettytable" cellpadding="10" border="1" | {| class="prettytable" cellpadding="10" border="1" | ||
| '''''Parameter Name''''' | | '''''Parameter Name''''' | ||
Line 326: | Line 495: | ||
|- | |- | ||
− | | | + | | number |
− | | The | + | | The number of characters for the end text. |
|} | |} | ||
Line 334: | Line 503: | ||
|- | |- | ||
| SUBSTITUTE | | SUBSTITUTE | ||
− | | | + | | Substitutes new text for old text in a string. |
{| class="prettytable" cellpadding="10" border="1" | {| class="prettytable" cellpadding="10" border="1" | ||
| '''''Parameter Name''''' | | '''''Parameter Name''''' | ||
Line 340: | Line 509: | ||
|- | |- | ||
− | | | + | | search_text |
− | | The | + | | The partial string to be (repeatedly) replaced. |
|- | |- | ||
− | | | + | | new text |
− | | The | + | | The text which is to replace the text string. |
|- | |- | ||
− | | | + | | occurrence |
− | | | + | | Which occurence of the old text is to be replaced. |
|} | |} | ||
Line 354: | Line 523: | ||
|- | |- | ||
| T | | T | ||
− | | | + | | Converts a value into text. |
| | | | ||
|- | |- | ||
| TEXT | | TEXT | ||
− | | | + | | Converts a number to text according to a given format. |
| | | | ||
|- | |- | ||
− | | | + | | TRIM |
− | | | + | | Removes extra spaces from text. |
| | | | ||
|- | |- | ||
− | | | + | | UNICHAR |
− | | | + | | Converts a code number into a Unicode character or letter. |
| | | | ||
|- | |- | ||
− | | | + | | UNICODE |
− | | | + | | Returns the numeric code for the first Unicode character in a text string. |
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
| | | | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
|- | |- | ||
− | | | + | | UPPER |
− | | | + | | Converts text to uppercase. |
| | | | ||
|- | |- | ||
− | | | + | | URLENCODE |
− | | | + | | Applies URL-Encoding to a text given in the first parameter using the encoding specified in the second parameter. If no encoding is given, ISO-8859-1 is assumed. |
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
{| class="prettytable" cellpadding="10" border="1" | {| class="prettytable" cellpadding="10" border="1" | ||
| '''''Parameter Name''''' | | '''''Parameter Name''''' | ||
Line 426: | Line 559: | ||
|- | |- | ||
− | | | + | | Encoding |
− | | | + | | The Encoding to be used. |
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
|} | |} | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
| | | | ||
|} | |} | ||
− | + | <br> | |
− | + | '''Rounding'''<br> | |
{| class="prettytable" cellpadding="10" border="1" | {| class="prettytable" cellpadding="10" border="1" | ||
| '''''Function Name''''' | | '''''Function Name''''' | ||
Line 460: | Line 573: | ||
|- | |- | ||
− | | | + | | INT |
− | | | + | | Rounds a number down to the nearest integer. |
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
| | | | ||
|} | |} | ||
<br> | <br> | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− |
Revision as of 13:48, 15 December 2008
Date/Time
Function Name | Description | Example | ||||||
DATE | Provides an internal number for the date given.
|
|||||||
DATEDIF | Returns the number of years, months, or days between two dates.
|
|||||||
DATEVALUE | Returns an internal number for a text having a possible date format. | |||||||
DAY | Returns the sequential date of the month as an integer (1-31) in relation to the date value. | |||||||
DAYS | Calculates the number of days between two dates.
|
|||||||
HOUR | Determines the sequential number of the hour of the day (0-23) for the time value. | |||||||
MINUTE | Determines the sequential number for the minute of the hour (0-59) for the time value. | |||||||
MONTH | Determines the sequential number of a month of the year (1-12) for the date value. | |||||||
NOW | Determines the current time of the computer. | |||||||
SECOND | Determines the sequential number of the second of a minute (0-59) for the time value. | |||||||
TIME | Determines a time value from the details for hour, minute and second.
|
|||||||
TIMEVALUE | Returns a sequential number for a text shown in a possible time entry format. | |||||||
TODAY | Determines the current date of the computer. | |||||||
WEEKDAY | Returns the day of the week for the date value as an integer (1-7).
|
|||||||
YEAR | Returns the year of a date value as an integer. |
Mathematical
Function Name | Description | Example | ||||
ABS | Absolute value of a number. | |||||
AVERAGE | Returns the average of a sample. | |||||
AVERAGE | Returns the average of a sample. | |||||
EVEN | Rounds a positive number up and negative number down to the nearest even integer. | |||||
MAX | Returns the maximum value in a list of arguments. | |||||
MAXA | Returns the maximum value in a list of arguments. Text is evaluated as zero. | |||||
MIN | Returns the minimum value in a list of arguments. | |||||
MINA | Returns the smallest value in a list of arguments. Text is evaluated as zero. | |||||
MOD | Calculates the remainder of a division.
|
|||||
ODD | Rounds a positive number up and negative number down to the nearest odd integer. | |||||
SUM | Returns the sum of all arguments. |
Logical
Function Name | Description | Example | ||||||
AND | Returns TRUE if all arguments are TRUE. | |||||||
FALSE | Defines the logical value as FALSE. | |||||||
IF | Specifies a logical test to be performed.
|
|||||||
NOT | Reverses the value of the argument. | |||||||
OR | Returns TRUE if an argument is TRUE. | |||||||
TRUE | Returns the logical value TRUE. | |||||||
XOR | Returns TRUE if a odd number of arguments are TRUE. |
Information
Function Name | Description | Example | ||||
CHOOSE | Selects a value from a list of up to 30 value arguments.
|
|||||
COUNT | Counts how many numbers are in the list of arguments. | |||||
COUNTA | Counts how many values are in the list of arguments. | |||||
COUNTBLANK | Counts the blank cells in a specified range. | |||||
HASCHANGED | Checks whether the columns specified by the given names has changed. | |||||
ISBLANK | Returns TRUE if value refers to an empty cell. | |||||
ISERR | Returns TRUE if the value is an error value not equal to #N/A. | |||||
ISERROR | Returns TRUE if the value is an error value. | |||||
ISEVEN | Returns TRUE if value is an even integer. | |||||
ISLOGICAL | Returns TRUE if the value carries a logical number format. | |||||
ISNA | Returns TRUE if value equals #N/A. | |||||
ISNONTEXT | Returns TRUE if the value is not text. | |||||
ISNUMBER | Returns TRUE if value is a number. | |||||
ISODD | Returns TRUE if value is an odd integer. | |||||
ISREF | Returns TRUE if value is a reference. | |||||
ISTEXT | Returns TRUE if value is text. | |||||
NA | Not available. Returns the error value #N/A. |
User-Defined
Function Name | Description | Example |
NULL | Returns a NULL-Value |
Text
Function Name | Description | Example | ||||||||
EXACT | Specifies whether two texts are identical.
|
|||||||||
FIND | Looks for a string of text within another (case sensitive)
|
|||||||||
LEFT | Returns the first character or characters of a text.
|
|||||||||
LEN | Calculates length of a text string. | |||||||||
LOWER | Converts text to lowercase. | |||||||||
MID | Returns a partial text string of a text.
|
|||||||||
REPLACE | Replaces characters within a text string with a different text string.
|
|||||||||
REPT | Repeats text a given number of times.
|
|||||||||
RIGHT | Returns the last character or characters of a text.
|
|||||||||
SUBSTITUTE | Substitutes new text for old text in a string.
|
|||||||||
T | Converts a value into text. | |||||||||
TEXT | Converts a number to text according to a given format. | |||||||||
TRIM | Removes extra spaces from text. | |||||||||
UNICHAR | Converts a code number into a Unicode character or letter. | |||||||||
UNICODE | Returns the numeric code for the first Unicode character in a text string. | |||||||||
UPPER | Converts text to uppercase. | |||||||||
URLENCODE | Applies URL-Encoding to a text given in the first parameter using the encoding specified in the second parameter. If no encoding is given, ISO-8859-1 is assumed.
|
Rounding
Function Name | Description | Example |
INT | Rounds a number down to the nearest integer. |