Syntax CONTAINS(string, substring) Output Boolean Definition Returns true if the given <string> contains the specified <substring>. Example CONTAINS("Calculation", "alcu") = true Notes See also the logical func
ASCII(string)/ CHAR(number) ASCII('A') = 65/ CHAR(65) = 'A' CONTAINS/ ENDSWITH/STARTSWITH(string,substring) Boolean CONTAINS(“Calculation”, “alcu”) = true; ENDSWITH(“Tableau”, “leau”) = true FIND(string, substring, [start]) Index/ 0(if not found) FIND("Calculation", "al...
LEN (string) Returns the length of the string. LEN("Tableau") = 7 LTRIM (string) Returns the string with any leading spaces removed. LTRIM(" Tableau ") = "Tableau" REPLACE (string, substring, replacement) Searches the string for substring and replaces it with a replacement. If the subst...