# Text Functions

- [ASCII](/cascade/functions-and-expressions/functions/text/ascii.md): Returns the ASCII code for a given character
- [CHAR](/cascade/functions-and-expressions/functions/text/char.md): Returns the character for a given ASCII code
- [CONCAT](/cascade/functions-and-expressions/functions/text/concat.md): Concatenates all inputs into a string
- [CONTAINS](/cascade/functions-and-expressions/functions/text/contains.md): Checks if a given column contains specified text
- [ENDSWITH](/cascade/functions-and-expressions/functions/text/endswith.md): Determines whether a given string ends with a specified substring
- [FIND](/cascade/functions-and-expressions/functions/text/find.md): Finds the index of a substring within a string
- [FINDNTH](/cascade/functions-and-expressions/functions/text/findnth.md): Returns the nth occurrence of a substring within a string
- [ISEMPTY](/cascade/functions-and-expressions/functions/text/isempty.md): Determines if value(s) are empty strings
- [JSONPARSE](/cascade/functions-and-expressions/functions/text/jsonparse.md): Extracts a single field from a json
- [LEFT](/cascade/functions-and-expressions/functions/text/left.md): Returns a certain numbers of characters within a string, counting from the left
- [LENGTH](/cascade/functions-and-expressions/functions/text/length.md): Returns the number of characters within a given text
- [LOWER](/cascade/functions-and-expressions/functions/text/lower.md): Returns a string, converted to lowercase
- [LTRIM](/cascade/functions-and-expressions/functions/text/ltrim.md): Removes leading whitespace
- [MID](/cascade/functions-and-expressions/functions/text/mid.md): Returns a portion of input text beginning at specified location
- [PROPER](/cascade/functions-and-expressions/functions/text/proper.md): Convert text strings to proper case
- [RIGHT](/cascade/functions-and-expressions/functions/text/right.md): Returns a certain numbers of characters within a string, counting from the right
- [RTRIM](/cascade/functions-and-expressions/functions/text/rtrim.md): Removes trailing whitespace
- [SPACE](/cascade/functions-and-expressions/functions/text/space.md): Produces desired number of spaces
- [SPLIT](/cascade/functions-and-expressions/functions/text/split.md): Split a string based on a given delimiter
- [STARTSWITH](/cascade/functions-and-expressions/functions/text/startswith.md): Determines whether a given string begins with a specified substring
- [TRIM](/cascade/functions-and-expressions/functions/text/trim.md): Removes leading, trailing and repeated whitespace from a text string
- [SUBSTITUTE](/cascade/functions-and-expressions/functions/text/substitute.md): Substitutes all instances of one value with another value
- [UPPER](/cascade/functions-and-expressions/functions/text/upper.md): Returns a string, converted to uppercase