# Functions - [Aggregate Functions](https://docs.cascade.io/cascade/functions-and-expressions/functions/aggregate.md) - [AVERAGE](https://docs.cascade.io/cascade/functions-and-expressions/functions/aggregate/average.md): Averages a list of numbers - [CORR](https://docs.cascade.io/cascade/functions-and-expressions/functions/aggregate/corr.md): Calculates a correlation coefficient - [COUNT](https://docs.cascade.io/cascade/functions-and-expressions/functions/aggregate/count.md): Returns the count of all non-null values in a column - [COUNTD](https://docs.cascade.io/cascade/functions-and-expressions/functions/aggregate/countd.md): Returns count of distinct values within a column - [COUNTBY](https://docs.cascade.io/cascade/functions-and-expressions/functions/aggregate/countby.md): Counts the number of values within a column, partitioned by the unique values of a separate column - [COUNTIF](https://docs.cascade.io/cascade/functions-and-expressions/functions/aggregate/countif.md): Counts values based on a condition - [COUNTIFS](https://docs.cascade.io/cascade/functions-and-expressions/functions/aggregate/countifs.md): Counts values based on multiple conditions - [COVAR](https://docs.cascade.io/cascade/functions-and-expressions/functions/aggregate/covar.md): Calculates covariance - [COVARP](https://docs.cascade.io/cascade/functions-and-expressions/functions/aggregate/covarp.md): Calculates population covariance - [COVARS](https://docs.cascade.io/cascade/functions-and-expressions/functions/aggregate/covars.md): Calculates sample covariance - [MAX](https://docs.cascade.io/cascade/functions-and-expressions/functions/aggregate/max.md): Finds maximum value in a list of numbers - [MEDIAN](https://docs.cascade.io/cascade/functions-and-expressions/functions/aggregate/median.md): Finds median value of a list of numbers - [MIN](https://docs.cascade.io/cascade/functions-and-expressions/functions/aggregate/min.md): Finds minimum value in a list of numbers - [MAXBY](https://docs.cascade.io/cascade/functions-and-expressions/functions/aggregate/maxby.md): Finds the maximum of a list of numbers, partitioned by the unique values of a separate column - [MINBY](https://docs.cascade.io/cascade/functions-and-expressions/functions/aggregate/minby.md): Finds the minimum of a list of numbers, partitioned by the unique values of a separate column - [PERCENTILE](https://docs.cascade.io/cascade/functions-and-expressions/functions/aggregate/percentile.md): Computes nth percentile of a list of numbers - [STDEV](https://docs.cascade.io/cascade/functions-and-expressions/functions/aggregate/stdev.md): Returns the standard deviation of a list of numbers - [STDEVP](https://docs.cascade.io/cascade/functions-and-expressions/functions/aggregate/stdevp.md): Returns the standard deviation of a list of numbers - [STDEVS](https://docs.cascade.io/cascade/functions-and-expressions/functions/aggregate/stdevs.md): Returns the sample standard deviation of a list of numbers - [SUM](https://docs.cascade.io/cascade/functions-and-expressions/functions/aggregate/sum.md): Sums a list of numbers - [SUMBY](https://docs.cascade.io/cascade/functions-and-expressions/functions/aggregate/sumby.md): Sums a list of numbers, partitioned by the unique values of a separate column - [SUMIF](https://docs.cascade.io/cascade/functions-and-expressions/functions/aggregate/sumif.md): Sums values within a column if specified criteria is met - [VAR](https://docs.cascade.io/cascade/functions-and-expressions/functions/aggregate/var.md): Calculates variance - [VARP](https://docs.cascade.io/cascade/functions-and-expressions/functions/aggregate/varp.md): Calculates a population variance - [VARS](https://docs.cascade.io/cascade/functions-and-expressions/functions/aggregate/vars.md): Calculates a sample variance - [RUNNINGTOTALBY](https://docs.cascade.io/cascade/functions-and-expressions/functions/aggregate/runningtotalby.md): Calculates a running total when grouped by a partition column - [SIGN](https://docs.cascade.io/cascade/functions-and-expressions/functions/aggregate/runningtotalby/sign.md): Determines the sign of a number - [SIN](https://docs.cascade.io/cascade/functions-and-expressions/functions/aggregate/runningtotalby/sin.md): Calculates the sine of an angle - [SQRT](https://docs.cascade.io/cascade/functions-and-expressions/functions/aggregate/runningtotalby/sqrt.md): Takes the square root of a given number - [SQUARE](https://docs.cascade.io/cascade/functions-and-expressions/functions/aggregate/runningtotalby/square.md): Squares a given number - [TAN](https://docs.cascade.io/cascade/functions-and-expressions/functions/aggregate/runningtotalby/tan.md): Calculates the tangent of an angle - [ZN](https://docs.cascade.io/cascade/functions-and-expressions/functions/aggregate/runningtotalby/zn.md): Fill all null values with 0 - [Conversion Functions](https://docs.cascade.io/cascade/functions-and-expressions/functions/conversion.md) - [TIMESTAMPTODATE](https://docs.cascade.io/cascade/functions-and-expressions/functions/conversion/timestamptodate.md): Converts a timestamp into a date/time value - [TODATE](https://docs.cascade.io/cascade/functions-and-expressions/functions/conversion/todate.md): Converts text into a date/time value - [TODECIMAL](https://docs.cascade.io/cascade/functions-and-expressions/functions/conversion/todecimal.md): Converts text into a decimal number - [TOINT](https://docs.cascade.io/cascade/functions-and-expressions/functions/conversion/toint.md): Converts text into an integer - [Date/Time Functions](https://docs.cascade.io/cascade/functions-and-expressions/functions/date-time.md) - [DATEADD](https://docs.cascade.io/cascade/functions-and-expressions/functions/date-time/dateadd.md): Adds or subtracts a specific number of time steps from a date - [DATEDIF](https://docs.cascade.io/cascade/functions-and-expressions/functions/date-time/datedif.md): Calculates the number of time steps between two dates - [DATENAME](https://docs.cascade.io/cascade/functions-and-expressions/functions/date-time/datename.md): Returns text corresponding to the specified part of a given date - [DATENORMALIZE](https://docs.cascade.io/cascade/functions-and-expressions/functions/date-time/datenormalize.md): Converts times to midnight - [DATEPART](https://docs.cascade.io/cascade/functions-and-expressions/functions/date-time/datepart.md): Returns the specified part of a given date - [DATETRUNC](https://docs.cascade.io/cascade/functions-and-expressions/functions/date-time/datetrunc.md): Truncates a date to the beginning of the specified period - [DAY](https://docs.cascade.io/cascade/functions-and-expressions/functions/date-time/day.md): Calculates the day of the month for a given date - [DAYS](https://docs.cascade.io/cascade/functions-and-expressions/functions/date-time/days.md): Calculates the number of days between two dates - [HOUR](https://docs.cascade.io/cascade/functions-and-expressions/functions/date-time/hour.md): Calculates the hour corresponding to a date/time value - [ISDATE](https://docs.cascade.io/cascade/functions-and-expressions/functions/date-time/isdate.md): Determines if a given date is a valid date - [ISOWEEKDAY](https://docs.cascade.io/cascade/functions-and-expressions/functions/date-time/isoweekday.md): Returns the ISO8601 weekday of a given date - [ISOWEEK](https://docs.cascade.io/cascade/functions-and-expressions/functions/date-time/isoweek.md): Returns the ISO8601 week of a given date - [ISOQUARTER](https://docs.cascade.io/cascade/functions-and-expressions/functions/date-time/isoquarter.md): Returns the ISO8601 quarter of a given date - [ISOYEAR](https://docs.cascade.io/cascade/functions-and-expressions/functions/date-time/isoyear.md): Returns the ISO8601 year of a given date - [MAKEDATE](https://docs.cascade.io/cascade/functions-and-expressions/functions/date-time/makedate.md): Create a date/time value from a given year, month, and day - [MAKEDATETIME](https://docs.cascade.io/cascade/functions-and-expressions/functions/date-time/makedatetime.md): Create a date/time value from a given date and time - [MINUTE](https://docs.cascade.io/cascade/functions-and-expressions/functions/date-time/minute.md): Calculates the minute corresponding to a date/time value - [MONTH](https://docs.cascade.io/cascade/functions-and-expressions/functions/date-time/month.md): Calculates the month for a given date - [NOW](https://docs.cascade.io/cascade/functions-and-expressions/functions/date-time/now.md): Returns current timestamp on local system - [QUARTER](https://docs.cascade.io/cascade/functions-and-expressions/functions/date-time/quarter.md): Returns the quarter of a given date - [SECOND](https://docs.cascade.io/cascade/functions-and-expressions/functions/date-time/second.md): Calculates the second corresponding to a date/time value - [TODAY](https://docs.cascade.io/cascade/functions-and-expressions/functions/date-time/today.md): Returns the current date - [WEEK](https://docs.cascade.io/cascade/functions-and-expressions/functions/date-time/week.md): Calculates the week for a given date - [WEEKDAY](https://docs.cascade.io/cascade/functions-and-expressions/functions/date-time/weekday.md): Converts a date into an integer corresponding to a day of the week - [YEAR](https://docs.cascade.io/cascade/functions-and-expressions/functions/date-time/year.md): Calculates the year for a given date - [Logical Functions](https://docs.cascade.io/cascade/functions-and-expressions/functions/logical.md) - [AND](https://docs.cascade.io/cascade/functions-and-expressions/functions/logical/and.md): Returns true if all items are true, otherwise returns false - [BETWEEN](https://docs.cascade.io/cascade/functions-and-expressions/functions/logical/between.md): Determines if given value is between two boundary values - [CASE](https://docs.cascade.io/cascade/functions-and-expressions/functions/logical/case.md): Returns specified values when condition is met - [CHOOSE](https://docs.cascade.io/cascade/functions-and-expressions/functions/logical/choose.md): Finds the value located at a specified index - [CONTAINSWITHIN](https://docs.cascade.io/cascade/functions-and-expressions/functions/logical/containswithin.md): Returns true if the given value exists within a column or list of values. - [IF](https://docs.cascade.io/cascade/functions-and-expressions/functions/logical/if.md): Tests whether expression is true or false and returns desired values accordingly - [IFS](https://docs.cascade.io/cascade/functions-and-expressions/functions/logical/ifs.md): Implements multiple if-then statements simultaneously - [IIF](https://docs.cascade.io/cascade/functions-and-expressions/functions/logical/iif.md): An if-then statement with capability of returning a third, unique value if condition is null - [IN](https://docs.cascade.io/cascade/functions-and-expressions/functions/logical/in.md): Returns true if the given value exists within a column or list of values. - [IFNULL](https://docs.cascade.io/cascade/functions-and-expressions/functions/logical/ifnull.md): Returns values dependent on if input values are null or not - [ISBOOLEAN](https://docs.cascade.io/cascade/functions-and-expressions/functions/logical/isboolean.md): Determine if given values are boolean - [ISDECIMAL](https://docs.cascade.io/cascade/functions-and-expressions/functions/logical/isdecimal.md): Determine if given values are decimals - [ISDURATION](https://docs.cascade.io/cascade/functions-and-expressions/functions/logical/isduration.md): Determine if given values are durations - [ISINTEGER](https://docs.cascade.io/cascade/functions-and-expressions/functions/logical/isinteger.md): Determine if given values are integers - [ISNULL](https://docs.cascade.io/cascade/functions-and-expressions/functions/logical/isnull.md): Returns true for null values and false otherwise - [ISNUMBER](https://docs.cascade.io/cascade/functions-and-expressions/functions/logical/isnumber.md): Determine if given values are numbers - [ISSTRING](https://docs.cascade.io/cascade/functions-and-expressions/functions/logical/isstring.md): Determine if given values are strings - [ISUNIQUE](https://docs.cascade.io/cascade/functions-and-expressions/functions/logical/isunique.md): Determines if the values in a column are unique - [NOT](https://docs.cascade.io/cascade/functions-and-expressions/functions/logical/not.md): Returns true when a condition is false and false otherwise - [NULL](https://docs.cascade.io/cascade/functions-and-expressions/functions/logical/null.md): Returns null value - [OR](https://docs.cascade.io/cascade/functions-and-expressions/functions/logical/or.md): Returns true if any of multiple conditions are true, otherwise returns false - [SWITCH](https://docs.cascade.io/cascade/functions-and-expressions/functions/logical/switch.md): Switches values with new values if original value matches key - [ALL](https://docs.cascade.io/cascade/functions-and-expressions/functions/logical/all.md): Determine if all elements of a column are true - [TOSTRING](https://docs.cascade.io/cascade/functions-and-expressions/functions/logical/all/tostring.md): Convert a value into a string - [ANY](https://docs.cascade.io/cascade/functions-and-expressions/functions/logical/any.md): Determine if any elements of a column are true - [Math Functions](https://docs.cascade.io/cascade/functions-and-expressions/functions/math.md) - [ABS](https://docs.cascade.io/cascade/functions-and-expressions/functions/math/abs.md): Calculates the absolute value of a number - [ACOS](https://docs.cascade.io/cascade/functions-and-expressions/functions/math/acos.md): Calculates the arc cosine of a number - [ASIN](https://docs.cascade.io/cascade/functions-and-expressions/functions/math/asin.md): Calculates the arc sine of a number - [ATAN](https://docs.cascade.io/cascade/functions-and-expressions/functions/math/atan.md): Calculates the arc tangent of a number - [ATAN2](https://docs.cascade.io/cascade/functions-and-expressions/functions/math/atan2.md): Calculates the arc tangent of an ordered pair - [CEILING](https://docs.cascade.io/cascade/functions-and-expressions/functions/math/ceiling.md): Rounds a given number up - [COS](https://docs.cascade.io/cascade/functions-and-expressions/functions/math/cos.md): Calculates the cosine of an angle - [COT](https://docs.cascade.io/cascade/functions-and-expressions/functions/math/cot.md): Calculates the cotangent of an angle - [COSEC](https://docs.cascade.io/cascade/functions-and-expressions/functions/math/cosec.md): Calculates the cosecant of an angle - [DEGREES](https://docs.cascade.io/cascade/functions-and-expressions/functions/math/degrees.md): Converts radians to degrees. - [DIV](https://docs.cascade.io/cascade/functions-and-expressions/functions/math/div.md): Returns the integer portion of a division operation - [EVEN](https://docs.cascade.io/cascade/functions-and-expressions/functions/math/even.md): Rounds a number up to the nearest even integer - [EXPONENTIAL](https://docs.cascade.io/cascade/functions-and-expressions/functions/math/exponential.md): Exponential function - [FILLINFINITY](https://docs.cascade.io/cascade/functions-and-expressions/functions/math/fillinfinity.md): Replace infinity values within input value - [FLOOR](https://docs.cascade.io/cascade/functions-and-expressions/functions/math/floor.md): Rounds a given number down - [HAVERSINE](https://docs.cascade.io/cascade/functions-and-expressions/functions/math/haversine.md): Calculates Haversine distance between coordinates - [LOG](https://docs.cascade.io/cascade/functions-and-expressions/functions/math/log.md): Logarithm function - [LN](https://docs.cascade.io/cascade/functions-and-expressions/functions/math/ln.md): Natural logarithm function - [ODD](https://docs.cascade.io/cascade/functions-and-expressions/functions/math/odd.md): Rounds a number up to the nearest odd integer - [MODULO](https://docs.cascade.io/cascade/functions-and-expressions/functions/math/modulo.md): Calculates the remainder of a division operation - [PERCENTILEOFVALUE](https://docs.cascade.io/cascade/functions-and-expressions/functions/math/percentileofvalue.md): Calculate percentiles based on data - [PERCENTILEVALUE](https://docs.cascade.io/cascade/functions-and-expressions/functions/math/percentilevalue.md): Calculate value(s) from specified percentiles - [PI](https://docs.cascade.io/cascade/functions-and-expressions/functions/math/pi.md): Returns the PI value - [POWER](https://docs.cascade.io/cascade/functions-and-expressions/functions/math/power.md): Raises a number to a specified exponent - [RADIANS](https://docs.cascade.io/cascade/functions-and-expressions/functions/math/radians.md): Converts degrees to radians. - [RANDOM](https://docs.cascade.io/cascade/functions-and-expressions/functions/math/random.md): Returns a random value between 0 and 1 - [ROUND](https://docs.cascade.io/cascade/functions-and-expressions/functions/math/round.md): Rounds a number or list of numbers - [SEC](https://docs.cascade.io/cascade/functions-and-expressions/functions/math/sec.md): Calculates the secant of an angle - [Table Functions](https://docs.cascade.io/cascade/functions-and-expressions/functions/table.md) - [ENCODE](https://docs.cascade.io/cascade/functions-and-expressions/functions/table/encode.md): Returns integers for each unique string value in a referenced column. - [INDEX](https://docs.cascade.io/cascade/functions-and-expressions/functions/table/index.md): Returns the value at a given index inside a column. - [INDEXBY](https://docs.cascade.io/cascade/functions-and-expressions/functions/table/indexby.md): Returns a value of a specific index within a column, partitioned by the unique values of a separate column - [FILLNULL](https://docs.cascade.io/cascade/functions-and-expressions/functions/table/fillnull.md): Fills null values with specified replacement value - [FIRSTBY](https://docs.cascade.io/cascade/functions-and-expressions/functions/table/firstby.md): Finds the first element within a column, partitioned by the unique values of a separate column - [GENERATEUNIQUEID](https://docs.cascade.io/cascade/functions-and-expressions/functions/table/generateuniqueid.md): Generates Unique IDs - [LASTBY](https://docs.cascade.io/cascade/functions-and-expressions/functions/table/lastby.md): Finds the last element within a column, partitioned by the unique values of a separate column - [LOOKUP](https://docs.cascade.io/cascade/functions-and-expressions/functions/table/lookup.md): Returns a row offset a given number of rows from the current row - [MATCH](https://docs.cascade.io/cascade/functions-and-expressions/functions/table/match.md): Returns the index of a matched value - [NTH](https://docs.cascade.io/cascade/functions-and-expressions/functions/table/nth.md): Returns the nth element of a given column - [OFFSET](https://docs.cascade.io/cascade/functions-and-expressions/functions/table/offset.md): Offsets values within a column - [OFFSETBY](https://docs.cascade.io/cascade/functions-and-expressions/functions/table/offsetby.md): Offsets values within a column, partitioned by the unique values of a separate column - [PREVIOUSVALUE](https://docs.cascade.io/cascade/functions-and-expressions/functions/table/previousvalue.md): Calculate a function's result based on the previous row's values - [RANK](https://docs.cascade.io/cascade/functions-and-expressions/functions/table/rank.md): Returns the rank of each element in a column - [RANKBY](https://docs.cascade.io/cascade/functions-and-expressions/functions/table/rankby.md): Ranks values within a column, partitioned by the unique values of a separate column - [RECORDID](https://docs.cascade.io/cascade/functions-and-expressions/functions/table/recordid.md): Generates IDs for each row in a table - [ROLLINGAVERAGE](https://docs.cascade.io/cascade/functions-and-expressions/functions/table/rollingaverage.md): Calculates the rolling averages of a column - [ROW](https://docs.cascade.io/cascade/functions-and-expressions/functions/table/row.md): Returns the current row number - [RUNNINGAVERAGE](https://docs.cascade.io/cascade/functions-and-expressions/functions/table/runningaverage.md): Calculates the running average of a column - [RUNNINGMAX](https://docs.cascade.io/cascade/functions-and-expressions/functions/table/runningmax.md): Calculates the running maximum of a column - [RUNNINGMIN](https://docs.cascade.io/cascade/functions-and-expressions/functions/table/runningmin.md): Calculates the running minimum of a column - [RUNNINGSTDEV](https://docs.cascade.io/cascade/functions-and-expressions/functions/table/runningstdev.md): Calculates the running standard deviation of a column - [RUNNINGTOTAL](https://docs.cascade.io/cascade/functions-and-expressions/functions/table/runningtotal.md): Calculates the running total of a column - [WINDOWAVERAGE](https://docs.cascade.io/cascade/functions-and-expressions/functions/table/windowaverage.md): Calculates rolling or static window average - [WINDOWMAX](https://docs.cascade.io/cascade/functions-and-expressions/functions/table/windowmax.md): Calculates rolling or static window maximum - [WINDOWMIN](https://docs.cascade.io/cascade/functions-and-expressions/functions/table/windowmin.md): Calculates rolling or static window minimum - [WINDOWCOUNT](https://docs.cascade.io/cascade/functions-and-expressions/functions/table/windowcount.md): Calculates rolling or static window count - [WINDOWSUM](https://docs.cascade.io/cascade/functions-and-expressions/functions/table/windowsum.md): Calculates rolling or static window sum - [SEQUENCE](https://docs.cascade.io/cascade/functions-and-expressions/functions/table/sequence.md): Create a sequence of numeric values - [WINDOWMEDIAN](https://docs.cascade.io/cascade/functions-and-expressions/functions/table/windowmedian.md): Calculates rolling or static window median - [WINDOWSTDEV](https://docs.cascade.io/cascade/functions-and-expressions/functions/table/windowstdev.md): Calculates rolling or static window population standard deviation - [WINDOWSTDEVP](https://docs.cascade.io/cascade/functions-and-expressions/functions/table/windowstdevp.md): Calculates rolling or static window population standard deviation - [WINDOWSTDEVS](https://docs.cascade.io/cascade/functions-and-expressions/functions/table/windowstdevs.md): Calculates rolling or static window sample standard deviation - [WINDOWVAR](https://docs.cascade.io/cascade/functions-and-expressions/functions/table/windowvar.md): Calculates rolling or static window average - [WINDOWVARP](https://docs.cascade.io/cascade/functions-and-expressions/functions/table/windowvarp.md): Calculates rolling or static window average - [WINDOWVARS](https://docs.cascade.io/cascade/functions-and-expressions/functions/table/windowvars.md): Calculates rolling or static window sample variance - [WINDOWCORR](https://docs.cascade.io/cascade/functions-and-expressions/functions/table/windowcorr.md): Calculates rolling or static window average - [WINDOWCOVAR](https://docs.cascade.io/cascade/functions-and-expressions/functions/table/windowcovar.md): Calculates rolling or static window population covariance - [WINDOWCOVARP](https://docs.cascade.io/cascade/functions-and-expressions/functions/table/windowcovarp.md): Calculates rolling or static window average - [WINDOWCOVARS](https://docs.cascade.io/cascade/functions-and-expressions/functions/table/windowcovars.md): Calculates rolling or static window sample covariance - [SMOOTHEDAVERAGE](https://docs.cascade.io/cascade/functions-and-expressions/functions/table/smoothedaverage.md): Calculates the smoothed averages of a column - [Text Functions](https://docs.cascade.io/cascade/functions-and-expressions/functions/text.md) - [ASCII](https://docs.cascade.io/cascade/functions-and-expressions/functions/text/ascii.md): Returns the ASCII code for a given character - [CHAR](https://docs.cascade.io/cascade/functions-and-expressions/functions/text/char.md): Returns the character for a given ASCII code - [CONCAT](https://docs.cascade.io/cascade/functions-and-expressions/functions/text/concat.md): Concatenates all inputs into a string - [CONTAINS](https://docs.cascade.io/cascade/functions-and-expressions/functions/text/contains.md): Checks if a given column contains specified text - [ENDSWITH](https://docs.cascade.io/cascade/functions-and-expressions/functions/text/endswith.md): Determines whether a given string ends with a specified substring - [FIND](https://docs.cascade.io/cascade/functions-and-expressions/functions/text/find.md): Finds the index of a substring within a string - [FINDNTH](https://docs.cascade.io/cascade/functions-and-expressions/functions/text/findnth.md): Returns the nth occurrence of a substring within a string - [ISEMPTY](https://docs.cascade.io/cascade/functions-and-expressions/functions/text/isempty.md): Determines if value(s) are empty strings - [JSONPARSE](https://docs.cascade.io/cascade/functions-and-expressions/functions/text/jsonparse.md): Extracts a single field from a json - [LEFT](https://docs.cascade.io/cascade/functions-and-expressions/functions/text/left.md): Returns a certain numbers of characters within a string, counting from the left - [LENGTH](https://docs.cascade.io/cascade/functions-and-expressions/functions/text/length.md): Returns the number of characters within a given text - [LOWER](https://docs.cascade.io/cascade/functions-and-expressions/functions/text/lower.md): Returns a string, converted to lowercase - [LTRIM](https://docs.cascade.io/cascade/functions-and-expressions/functions/text/ltrim.md): Removes leading whitespace - [MID](https://docs.cascade.io/cascade/functions-and-expressions/functions/text/mid.md): Returns a portion of input text beginning at specified location - [PROPER](https://docs.cascade.io/cascade/functions-and-expressions/functions/text/proper.md): Convert text strings to proper case - [RIGHT](https://docs.cascade.io/cascade/functions-and-expressions/functions/text/right.md): Returns a certain numbers of characters within a string, counting from the right - [RTRIM](https://docs.cascade.io/cascade/functions-and-expressions/functions/text/rtrim.md): Removes trailing whitespace - [SPACE](https://docs.cascade.io/cascade/functions-and-expressions/functions/text/space.md): Produces desired number of spaces - [SPLIT](https://docs.cascade.io/cascade/functions-and-expressions/functions/text/split.md): Split a string based on a given delimiter - [STARTSWITH](https://docs.cascade.io/cascade/functions-and-expressions/functions/text/startswith.md): Determines whether a given string begins with a specified substring - [TRIM](https://docs.cascade.io/cascade/functions-and-expressions/functions/text/trim.md): Removes leading, trailing and repeated whitespace from a text string - [SUBSTITUTE](https://docs.cascade.io/cascade/functions-and-expressions/functions/text/substitute.md): Substitutes all instances of one value with another value - [UPPER](https://docs.cascade.io/cascade/functions-and-expressions/functions/text/upper.md): Returns a string, converted to uppercase --- # 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.cascade.io/cascade/functions-and-expressions/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.