asc
($text as xs:string) as xs:string
Returns the given $text unchanged. |
char
($number as xs:integer) as xs:string
Returns the character specified by a certain codepoint. |
clean
($arg as xs:string?) as xs:string?
Removes all nonprintable characters from text. |
code
($arg as xs:string) as xs:integer
Returns a codepoint for the first character in a text string. |
concatenate
($args as xs:anyAtomicType*) as xs:string
Joins several text strings into one text string. |
concatenate
($arg1 as xs:anyAtomicType?, $arg2 as xs:anyAtomicType?) as xs:string
Joins two text strings into one text string. |
dollar
($number as xs:decimal) as xs:string
Converts a number to text format and applies a currency symbol. |
dollar
($number as xs:decimal, $decimals as xs:decimal) as xs:string
Converts a number to text format and applies a currency symbol. |
exact
($arg1 as xs:string, $arg2 as xs:string) as xs:boolean
Compares two text strings and returns TRUE if they are exactly the same, FALSE otherwise. |
find
($find_text as xs:string, $within_text as xs:string) as xs:integer?
Locate one text string within a second text string, and return the number of the starting position of the first text string from the first character of the second text string. |
find
($find_text as xs:string, $within_text as xs:string, $start_num as xs:integer) as xs:integer?
Locate one text string within a second text string, and return the number of the starting position of the first text string from the first character of the second text string. |
fixed
($number as xs:decimal, $decimals as xs:decimal) as xs:string
Rounds a number to the specified number of decimals, formats the number in decimal format using a period and commas, and returns the result as text. |
fixed
($number as xs:decimal, $decimals as xs:decimal, $no_commas as xs:boolean) as xs:string
Rounds a number to the specified number of decimals, formats the number in decimal format using a period and commas, and returns the result as text. |
left
($arg as xs:string) as xs:string
Returns the first character in a text string. |
left
($text as xs:string, $num_chars as xs:integer) as xs:string
Returns the first character or characters in $text, based on the number of $num_chars you specify. |
len
($arg as xs:string?) as xs:integer
Returns the number of characters in a text string. |
lower
($arg as xs:string?) as xs:string?
Converts all uppercase letters in a text string to lowercase. |
mid
($text as xs:string?, $start_num as xs:integer, $num_chars as xs:integer) as xs:string?
Returns a specific number of characters from a text string, starting at the position you specify, based on the number of characters you specify. |
pad-integer-to-length
($toPad as xs:anyAtomicType?, $padChar as xs:string, $length as xs:integer) as xs:string
Returns $toPad appended with enough repetitions of $padChar to make its length $length, the characters are added before the string. |
replace
($old_text as xs:string?, $start_num as xs:integer, $num_chars as xs:integer, $new_text as xs:string) as xs:string
Replaces part of a text string, based on the number of characters you specify, with a different text string. |
right
($arg as xs:string) as xs:string
Returns the last character in a text string. |
right
($text as xs:string, $num_chars as xs:integer) as xs:string
Returns the last character or characters in a text string, based on the number of characters you specify. |
search
($find_text as xs:string, $within_text as xs:string) as xs:integer?
Locate one text string within a second text string, and return the number of the starting position of the first text string from the first character of the second text string. |
search
($find_text as xs:string, $within_text as xs:string, $start_num as xs:integer) as xs:integer?
Locate one text string within a second text string, and return the number of the starting position of the first text string from the first character of the second text string. |
substitute
($text as xs:string, $old_text as xs:string, $new_text as xs:string) as xs:string?
Substitutes new_text for old_text in a text string. |
substitute
($text as xs:string, $old_text as xs:string, $new_text as xs:string, $instance_num as xs:integer?) as xs:string
Substitutes new_text for old_text in a text string. |
t
($value as xs:anyAtomicType?) as xs:string
Converts the $value to string. |
trim
($text as xs:string?) as xs:string?
Removes all spaces from text except for single spaces between words. |
upper
($text as xs:string?) as xs:string?
Converts text to uppercase. |
value-except
($arg1 as xs:anyAtomicType*, $arg2 as xs:anyAtomicType*) as xs:anyAtomicType*
Returns the values in one sequence that do not appear in the second sequence in an implementation-defined order. |
value
($arg as xs:anyAtomicType?) as xs:anyAtomicType?
Converts a text string that represents a number to a number. |
declare function excel-text:asc($text as xs:string) as xs:string
declare function excel-text:char($number as xs:integer) as xs:string
declare function excel-text:clean($arg as xs:string?) as xs:string?
In the Unicode character set, there are additional nonprinting characters (values 127, 129, 141, 143, 144, and 157).
By itself, the CLEAN function does not remove these additional nonprinting characters.
declare function excel-text:code($arg as xs:string) as xs:integer
declare function excel-text:concatenate($args as xs:anyAtomicType*) as xs:string
declare function excel-text:concatenate($arg1 as xs:anyAtomicType?, $arg2 as xs:anyAtomicType?) as xs:string
declare function excel-text:dollar($number as xs:decimal) as xs:string
declare function excel-text:dollar($number as xs:decimal, $decimals as xs:decimal) as xs:string
If decimals is negative, number is rounded to the left of the decimal point.
declare function excel-text:exact($arg1 as xs:string, $arg2 as xs:string) as xs:boolean
declare function excel-text:find($find_text as xs:string, $within_text as xs:string) as xs:integer?
The search is case sensitive.
The search is case sensitive.
declare function excel-text:find($find_text as xs:string, $within_text as xs:string, $start_num as xs:integer) as xs:integer?
The search is case sensitive.
The search is case sensitive.
declare function excel-text:fixed($number as xs:decimal, $decimals as xs:decimal) as xs:string
declare function excel-text:fixed($number as xs:decimal, $decimals as xs:decimal, $no_commas as xs:boolean) as xs:string
declare function excel-text:left($arg as xs:string) as xs:string
declare function excel-text:left($text as xs:string, $num_chars as xs:integer) as xs:string
declare function excel-text:len($arg as xs:string?) as xs:integer
declare function excel-text:lower($arg as xs:string?) as xs:string?
declare function excel-text:mid($text as xs:string?, $start_num as xs:integer, $num_chars as xs:integer) as xs:string?
declare function excel-text:pad-integer-to-length($toPad as xs:anyAtomicType?, $padChar as xs:string, $length as xs:integer) as xs:string
declare function excel-text:replace($old_text as xs:string?, $start_num as xs:integer, $num_chars as xs:integer, $new_text as xs:string) as xs:string
declare function excel-text:right($arg as xs:string) as xs:string
declare function excel-text:right($text as xs:string, $num_chars as xs:integer) as xs:string
declare function excel-text:search($find_text as xs:string, $within_text as xs:string) as xs:integer?
The search starts at position 1, and it is not case sensitive.
The search starts at position 1, and it is not case sensitive.
declare function excel-text:search($find_text as xs:string, $within_text as xs:string, $start_num as xs:integer) as xs:integer?
The search starts at $start_num, and it is not case sensitive.
The search starts at $start_num, and it is not case sensitive.
declare function excel-text:substitute($text as xs:string, $old_text as xs:string, $new_text as xs:string) as xs:string?
declare function excel-text:substitute($text as xs:string, $old_text as xs:string, $new_text as xs:string, $instance_num as xs:integer?) as xs:string
Only that instance of old_text is replaced.
Use SUBSTITUTE when you want to replace specific text in a text string; use REPLACE when you want to replace any text that occurs in a specific location in a text string.
declare function excel-text:t($value as xs:anyAtomicType?) as xs:string
declare function excel-text:trim($text as xs:string?) as xs:string?
declare function excel-text:upper($text as xs:string?) as xs:string?
declare function excel-text:value-except($arg1 as xs:anyAtomicType*, $arg2 as xs:anyAtomicType*) as xs:anyAtomicType*
declare function excel-text:value($arg as xs:anyAtomicType?) as xs:anyAtomicType?