Text Functions


Excel Function	1010data Function	Description
`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.
`VALUE(text)`	`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.
`CONCATENATE(text1,[text2],...)`	`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.