TEXT(value,format_text) |
string(X) |
Returns the input value expressed as a text string. |
VALUE(text) |
int(X) |
For Excel, it converts the selected string value into a numeric value. For
1010data, it returns the largest integer less than or equal to the given value,
expressed as an integer number. |
real(X) |
For Excel, it converts the selected string value into a numeric value. For
1010data, it returns the given value expressed as a decimal number. |
LOWER(text) |
lowercase(X) |
Returns a given string converted to all lowercase. |
UPPER(text) |
uppercase(X) |
Returns a given string converted to all uppercase. |
REPLACE(old_text,start_num,num_chars,new_text) |
stredit(X;P;N;Y) |
Returns a given string, with a specified number of characters starting at a
certain position replaced by a given substring. |
SUBSTITUTE(text,old_text,new_text,[instance_num}) |
strsubst(X;Y;I;Z) |
Returns the given string with a particular occurrence (or all occurrences) of a
given substring replaced with a different substring. |
CONCATENATE(text1,[text2],...) |
splice(X;Y) |
Returns a string consisting of the list of given values concatenated together
using the specified separator. |
colunion(X;Y) |
Returns a string consisting of the union of values from a given set of columns
concatenated together using the specified separator, sorted in ascending
order. |
LEFT(text,[num_chars]) |
padright(X;Y) |
Returns the given string with a certain number of characters, adding blanks at
the end if necessary. |
RIGHT(text,[num_chars]) |
padleft(X;Y) |
Returns the given string with a certain number of characters, adding blanks at
the beginning if necessary. |
LEN(text) |
strlen(X) |
Returns the number of characters in a given string. |
FIND(find_text,within_text,[start_num]) |
strfind(X;Y;I) |
Returns the position within a given string of a particular occurrence of a given
substring. |
