Text Functions

ASCThe text string converted from double byte to single byte characters.
BAHTTEXTThe number converted to a Thai text string and appends 'Baht'.
CHARThe character with the corresponding ANSI/ASCII number.
CLEANThe text string with all the non-printable characters removed.
CODEThe ANSI/ASCII number for the first character in a text string.
CONCAT(2016) The text string that is a concatenation of several strings.
CONCATENATE(CONCAT) The text string that is a concatenation of several strings.
DBCS(2013) The text string converted from single byte to double byte characters.
DOLLARThe text string of a number with the dollar formatting $0,000.00.
EXACTThe value True or False based on whether two strings match exactly.
FINDThe position of a substring within a larger text string.
FIXEDThe text string of a number rounded to a fixed number of decimal places.
JIS(DBCS) The text string converted from single byte to double byte characters (renamed).
LEFTThe first or left most characters in a text string.
LENThe number of characters in a text string.
LOWERThe text string with all the characters converted to lowercase.
MIDThe text string which is a substring of a given string.
NUMBERVALUE(2013) The number that a text string represents (current locale).
PHONETICThe phonetic characters from a text string.
PROPERThe text string with the first letter of every word as a capital letter.
REPLACEThe text string after replacing characters in a specific location.
REPTThe text string repeated a number of times.
RIGHTThe last or right most characters in a text string.
SEARCHThe position of a substring within a larger text string.
SUBSTITUTEThe text string after replacing instances of a substring.
TThe text string of the value given.
TEXTThe number as a formatted text string.
TEXTJOIN(2016) The text string that is a concatenation of several strings (with delimiter).
TRIMThe text string with all extra spaces removed from the beginning, middle and end.
UNICHAR(2013) The character with the corresponding UNICODE character.
UNICODE(2013) The UNICODE number for the first character in a text string.
UPPERThe text string with all the characters converted to uppercase.
VALUE(NUMBERVALUE) The number that a text string represents.
ASC
The text string converted from double byte to single byte characters.
BAHTTEXT
The number converted to a Thai text string and appends 'Baht'.
CHAR
The character with the corresponding ANSI/ASCII number.
CLEAN
The text string with all the non-printable characters removed.
CODE
The ANSI/ASCII number for the first character in a text string.
CONCAT
(2016) The text string that is a concatenation of several strings.
CONCATENATE
(CONCAT) The text string that is a concatenation of several strings.
DBCS
(2013) The text string converted from single byte to double byte characters.
DOLLAR
The text string of a number with the dollar formatting $0,000.00.
EXACT
The value True or False based on whether two strings match exactly.
FIND
The position of a substring within a larger text string.
FIXED
The text string of a number rounded to a fixed number of decimal places.
JIS
(DBCS) The text string converted from single byte to double byte characters (renamed).
LEFT
The first or left most characters in a text string.
LEN
The number of characters in a text string.
LOWER
The text string with all the characters converted to lowercase.
MID
The text string which is a substring of a given string.
NUMBERVALUE
(2013) The number that a text string represents (current locale).
PHONETIC
The phonetic characters from a text string.
PROPER
The text string with the first letter of every word as a capital letter.
REPLACE
The text string after replacing characters in a specific location.
REPT
The text string repeated a number of times.
RIGHT
The last or right most characters in a text string.
SEARCH
The position of a substring within a larger text string.
SUBSTITUTE
The text string after replacing instances of a substring.
T
The text string of the value given.
TEXT
The number as a formatted text string.
TEXTJOIN
(2016) The text string that is a concatenation of several strings (with delimiter).
TRIM
The text string with all extra spaces removed from the beginning, middle and end.
UNICHAR
(2013) The character with the corresponding UNICODE character.
UNICODE
(2013) The UNICODE number for the first character in a text string.
UPPER
The text string with all the characters converted to uppercase.
VALUE
(NUMBERVALUE) The number that a text string represents.

© 2019 Better Solutions Limited. All Rights Reserved. © 2019 Better Solutions Limited Top