Formulas & functions
How a function works, with worked examples you can paste.
- String Functions in SQL: Full Guide with ExamplesString functions in SQL are built-in operations that let you manipulate, format, and extract text data stored in character columns. The most…
- Replace Function in Snowflake: How to Use ItThe REPLACE function in Snowflake replaces every occurrence of a specified substring within a string with a new substring. Its syntax is…
- MIN Function in Snowflake: Syntax and ExamplesThe MIN function in Snowflake returns the minimum value from a set of numeric, string, or date/timestamp values, ignoring NULLs by default.…
- PostgreSQL Call a Function: Syntax and ExamplesTo call a function in PostgreSQL, you use the SELECT statement with the function name and its arguments, like SELECT function_name(arg1, arg2);.…
- How to Use Functions in JavaScriptFunctions are reusable blocks of code that perform a specific task. They help you avoid repetition, organize your code, and make it…
- Excel AVERAGEIF Not NA: Exclude Errors & TextTo average a range in Excel while ignoring #N/A errors (and other errors), you cannot use AVERAGEIF alone—it ignores text and blank…
- Excel Average by Range: Formula & ExamplesTo average a range of cells in Excel, use the AVERAGE function: =AVERAGE(A1:A10) averages all numeric values in cells A1 through A10.…
- Flatten Function in Snowflake: How to Use ItThe FLATTEN function in Snowflake converts a nested array or object into a set of rows, effectively unpivoting semi-structured data like JSON…
- How to Make a Function in C++ (Step-by-Step)In C++, a function is a reusable block of code that performs a specific task. You call it by name whenever you…
- Table Valued Function Databricks: How to UseA table-valued function (TVF) in Databricks is a user-defined function that returns a table (a set of rows and columns) instead of…
- Excel Average by Date: Formula & ExamplesTo average values by date in Excel, use the AVERAGEIF function with the date range as the criteria range and a date…
- Snowflake Function Return Table: How It WorksYes, Snowflake functions can return a table, and the two main ways to do it are with a SQL user-defined function (UDF)…
- C++ String Functions: How to Use ThemString functions in C++ let you manipulate text easily—finding substrings, changing case, comparing, concatenating, and extracting parts. This guide covers the essential…
- String length function in JS: .length explainedThe string length function in JavaScript is the .length property, used as myString.length. It returns the number of UTF-16 code units in…
- Split Function in VBScript: Syntax, Examples, and UsesThe Split function in VBScript returns a zero-based, one-dimensional array containing a specified number of substrings, divided from a larger string based…
- Function Call Split? How to Divide Calls in ExcelYes, you can split a function call in Excel by nesting one function inside another, separating arguments with commas, or using the…
- Substring Function in JS: How to Use substr, substring, sliceThe substring function in JavaScript is String.prototype.substring(), which returns a portion of a string between two indices. For example, 'Hello World'.substring(0, 5)…
- How to Create a Function in DatabricksCreating a user-defined function (UDF) in Databricks lets you encapsulate custom logic in Python, SQL, or Scala and reuse it across notebooks,…
- SPLIT Function Usage in ExcelThe SPLIT function does not exist in Excel; the correct way to split text in Excel is to use the TEXTSPLIT function…
- System Function in Ignition: How It WorksThe system function in an ignition system is to generate a high-voltage spark at the right moment to ignite the air-fuel mixture…
- Split Function Test: How It Works in ExcelA split function test checks whether a text-splitting formula or tool correctly divides a string into the expected parts. In Excel, the…
- How to Execute a Function in PostgreSQLExecuting a function in PostgreSQL means calling it so it runs its SQL logic and returns a result. You can call a…
- Python len() of String: How It Works & ExamplesThe len() function in Python returns the number of characters in a string. For example, len("hello") returns 5. This built-in function works…
- String Function ComfyUI: How to Use ItIn ComfyUI, “string function” refers to the built-in nodes that let you manipulate text values within your workflow—such as concatenating, formatting, searching,…
- How to Define a Function in C++Defining a function in C++ lets you package a block of code under a name so you can call it repeatedly, pass…
- Postgres Function Return Table? ExplainedYes, a PostgreSQL function can return a table by using RETURNS TABLE (...) in its definition, which lets you return multiple rows…
- String Functions in PHP: W3Schools GuidePHP string functions are built-in tools for manipulating text, and W3Schools documents them with examples, syntax, and a full reference list. This…
- Tableau NOT IN Function: Syntax, Use & FixesThe short answer: Tableau does not have a dedicated NOT IN function. You achieve the same logic by writing NOT ( [Field]…
- Oracle SQL String Length Function: LENGTH ExplainedThe Oracle SQL function for string length is LENGTH, and you use it as LENGTH(string) to return the number of characters in…
- Split Function in Databricks: How to Use ItThe split() function in Databricks SQL and PySpark splits a string into an array of substrings based on a delimiter. To use…