CHAR | CHAR(number) |
CLEAN | CLEAN(text) |
CODE | CODE(text) |
CONCAT | CONCAT(text1, [text2], ...) |
CONCATENATE | CONCATENATE(text1,text2,...) |
DOLLAR | DOLLAR(number,decimals) |
EXACT | EXACT(text1,text2) |
FIND | FIND(find_text, within_text, [start_num]) |
LEFT | LEFT(text,num_chars) |
LEN | LEN(text) |
LOWER | LOWER(text) |
MID | MID(text,start_num,num_chars) |
PROPER | PROPER(text) |
REPLACE | REPLACE(old_text,start_num,num_chars,new_text) |
REPT | REPT(text,number_times) |
RIGHT | RIGHT(text,num_chars) |
SEARCH | SEARCH(find_text,within_text,start_num) |
SUBSTITUTE | SUBSTITUTE(text,old_text,new_text,instance_num) |
TEXT | TEXT(value,format_text) |
TEXTAFTER | TEXTAFTER(text,delimiter,[instance_num], [match_mode], [match_end], [if_not_found]) |
TEXTBEFORE | TEXTBEFORE(text,delimiter,[instance_num], [match_mode], [match_end], [if_not_found]) |
TEXTSPLIT | TEXTSPLIT(text,col_delimiter,[row_delimiter],[ignore_empty], [match_mode], [pad_with]) |
TEXTJOIN | TEXTJOIN(delimiter, ignore_empty, text1, [text2], ...) |
TRIM | TRIM(text) |
UPPER | UPPER(text) |
VALUE | VALUE(text) |