# String Functions ## CONCAT `CONCAT(string1, string2...)` **Description** Concatenate one or more strings into a single string. **Example** ``` CONCAT("Acho", "_", "Studio") ``` Result: Acho\_Studio ## ASCII `ASCII(string)` **Description** Return the ASCII code value of the first character in a string. **Example** ``` ASCII('a') ``` Result: 97 ``` ASCII('acho') ``` Result: 97 ## ENDS\_WITH `ENDS_WITH(string, substring)` **Description** Return `True` if the string ends with the substring. **Example** ``` ENDS_WITH("Acho", "o") ``` Result: True ``` ENDS_WITH("Apple", "o") ``` Result: False ## INITCAP `INITCAP(string, [delimiters])` **Description** Make the first letter of each word uppercase and the rest of the letters lowercase. Words are delimited by white space or other characters that you can specify in delimiters. **Example** ``` INITCAP("acho studio") ``` Result: "Acho Studio" ``` INITCAP("ACHO_STUDIO", "_") ``` Result: "Acho\_Studio" ## INSTR `INSTR(string, subsstring, [position], [occurence])` **Description** Return the position of the first substring in the string. 0 is returned when no match is found. Position determines where the search starts in a string. Occurrence refers to extract the i-th occurrence (ex: 2 means second occurrence). **Example** ``` INSTR("Acho Studio", "o"), ``` Result: 4 (the position of the first "o") ``` INSTR("Acho Studio", "o", 6), ``` Result: 11 (the position of the first "o" from the sixth character) ``` INSTR("Acho Studio", "o", 1, 2) ``` Result: 2 (the position of the second "o" from the first character) ## LEFT `LEFT(string, num_chars)` **Description** Return the specified number of characters from the start of the given string. **Example** ``` LEFT("Acho", 2) ``` Result: "Ac" ## LENGTH `LENGTH(string)` **Description** Return the length of a string in characters or bytes. **Example** ``` LENGTH('acho') ``` Result: 4 ## LOWER `LOWER(string)` **Description** Convert a text string to all lowercase letters. **Example** ``` LOWER("ACHO") ``` Result: "acho" ## LTRIM `LTRIM(string, [substring])` **Description** Remove all leading spaces. If you want to remove strings other than spaces, you can optionally specify a substring. **Example** ``` TRIM(" Acho ") ``` Result: "Acho " ``` TRIM("###Acho#", "#") ``` Result: "Acho#" ## REGEXP\_CONTAINS `REGEXP_CONTAINS(string, regexp)` **Description** Return `True` if a string is a partial match for the regular expression pattern. To see supported regular expression, visit [here](https://docs.acho.io/). **Example** ``` REGEXP_CONTAINS("contact@acho.io", r"@[a-zA-Z0-9-]+\.[a-zA-Z0-9-.]+") ``` Result: True ``` REGEXP_CONTAINS("acho.io", r"@[a-zA-Z0-9-]+\.[a-zA-Z0-9-.]+") ``` Result: False ## REGEXP\_EXTRACT `REGEXP_EXTRACT(string, regexp, position, occurence)` **Description** Extracts the substring of the given string that matches the regular expression pattern. Returns NULL if there is no match. To see supported regular expression, visit [here](https://docs.acho.io/). Position determines where the search starts in a string. Occurrence refers to extract i-th occurrence (ex: 2 means second occurrence). **Example** ``` REGEXP_EXTRACT("contact@acho.io", r"^[a-zA-Z0-9_.+-]+") ``` Result: "contact" ## REPLACE `REPLACE(original_string, from_value, to_value)` **Description** Replace all occurrences of from\_value with to\_value in original\_string. If the from\_value is not found, the string is unchanged. **Example** ``` REPLACE("apple pie", "pie", "cobbler") ``` Result: "apple cobbler" ## RIGHT `RIGHT(string, num_chars)` **Description** Return the specified number of characters from the end of the given string. **Example** ``` RIGHT("Acho", 2) ``` Result: "ho" ## RTRIM `RTRIM(string, [substring])` **Description** Remove all trailing spaces. If you want to remove strings other than spaces, you can optionally specify a substring. **Example** ``` TRIM(" Acho ") ``` Result: " Acho" ``` TRIM("###Acho#", "#") ``` Result: "###Acho" ## STARTS\_WITH `STARTS_WITH(string, substring)` **Description** Return True if the string ends with the substring. **Example** ``` ENDS_WITH("Acho", "A") ``` Result: True ``` ENDS_WITH("Acho", "E") ``` Result: False ## STRPOS `STRPOS(string, substring)` **Description** Return the position of the substring within a specified string. If the substring occurs in several positions, it will only return the first occurrence. **Example** ``` STRPOS('Acho Studio', 'o') ``` Result: 4 ## SUBSTR `SUBSTR(string, position, [length])` **Description** Extract a substring from the given string, which starts at the position. The position refers to the position of a character in the given string. You can optionally specify the length to decide the number of characters that you want to extract. **Example** ``` SUBSTR("Acho Studio", 3) ``` ``` Return: "ho Studio" ``` ``` SUBSTR("Acho Studio", 4, 5) ``` ``` Return: "o Stu" ``` ## TRIM `TRIM(string, [substring])` **Description** Remove all leading and trailing spaces. If you want to remove strings other than spaces, you can optionally specify a substring. **Example** ``` TRIM(" Acho ") ``` Result: "Acho" ``` TRIM("###Acho#", "#") ``` Result: "Acho" ## UPPER `UPPER(string)` **Description** Convert a text string to all uppercase letters. **Example** ``` UPPER("Acho") ``` Result: "ACHO" --- # Agent Instructions: Querying This Documentation If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question. Perform an HTTP GET request on the current page URL with the `ask` query parameter: ``` GET https://docs.acho.io/acho-studio/data-prep-projects/applying-actions/tools/sql-editor/supported-math-functions-in-formula/string-functions.md?ask= ``` The question should be specific, self-contained, and written in natural language. The response will contain a direct answer to the question and relevant excerpts and sources from the documentation. Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.