Skip to main content

Text functions

NameDescriptionSyntax
ASCConverts full-width (double-byte) characters that are typical for East Asian languages into standard-width (single-byte) charactersASC(string)
DBCSConverts standard-width (single-byte) characters into full-width (double-byte) characters that are typical for East Asian languagesDBCS(string)
JISConverts standard-width (single-byte) characters into full-width (double-byte) characters that are typical for East Asian languagesJIS(string)
UNICODEReturns the Unicode value of the first character in a stringUNICODE(string)
LENBReturns the length of a string in bytesLENB(string)
LENReturns the length of a string in charactersLEN(string)
VALUEConverts a value entered in text format into a numberVALUE(text)
CODEReturns the code of the first character in a string based on the system language and the encoding used on the deviceCODE(string)
LEFTBReturns a specific number of characters from the beginning of a string, based on the given amount of bytesLEFTB(string, [num_bytes])
LEFTReturns the given number of characters from the beginning of a stringLEFT(string, [num_characters])
FINDReturns the position of the searched text within the viewed text. Counts double-byte characters as 1 character. The function is case sensitiveFIND(find_text, within_text, [start_num])
FINDBReturns the position of the searched text within the viewed text. Counts double-byte characters, such as hieroglyphs, as 2 characters. The function is case sensitiveFINDB(find_text, within_text, [start_num])
CLEANRemoves all non-printable characters from a textCLEAN(text)
SUBSTITUTEReplaces a certain text in a string with another oneSUBSTITUTE(string, old_text, new_text, [instance_num])
SEARCHReturns the position of the searched text within the viewed text. Counts double-byte characters as 1 characterSEARCH(find_text, within_text, [start_num])
SEARCHBReturns the position of the searched text within the viewed text. Counts double-byte characters, such as hieroglyphs, as 2 charactersSEARCHB(find_text, within_text, [start_num])
RIGHTBReturns a specific number of characters from the end of a string, based on the given amount of bytesRIGHTB(string, [num_bytes])
RIGHTReturns the given number of characters from the end of a stringRIGHT(string, [num_characters])
UPPERReturns a string where all letters are uppercaseUPPER(string)
PROPERReturns a string where the first letter of each word is uppercase and the rest are lowercasePROPER(string)
MIDReturns the given number of characters from a string starting from the specified positionMID(string, start_num, num_characters)
MIDBReturns a specific number of characters from a string based on the given amount of bytes starting from the defined positionMIDB(string, start_num, num_bytes)
TRIMRemoves all extra spaces from the string, leaving only single spaces between wordsTRIM(string)
EXACTCompares two strings and returns TRUE if they are exactly the same, FALSE otherwise. The function is case-sensitive but ignores formatting differencesEXACT(string1, string2)
LOWERReturns a string where all letters are lowercaseLOWER(string)
CONCATENATEReturns a string assembled from multiple stringsCONCATENATE(string1, [string2, ...])
TEXTConverts a value into a string of a given formatTEXT(value, format)