Formulas & functions
How a function works, with worked examples you can paste.
- MySQL String Functions and Operators ExplainedMySQL string functions transform, measure, search, and combine text; string operators compare text or match patterns. For example, use CONCAT(first_name, ' ',…
- Excel Split Function: How to Split Text into ColumnsIn Excel for Microsoft 365, the function for splitting a text string is TEXTSPLIT. It separates text at a delimiter, such as…
- Arduino Parts and Functions: What Each Component DoesAn Arduino board is a small, programmable circuit board used to read inputs and control outputs. Its main parts are a microcontroller,…
- Excel TEXTSPLIT Function Syntax, Examples, and TipsIn Excel for Microsoft 365, the split function is TEXTSPLIT, with the syntax TEXTSPLIT(text, col_delimiter, [row_delimiter], [ignore_empty], [match_mode], [pad_with]). For example, with…
- PHP String Functions: A Practical Guide to Working With TextPHP string functions are built-in tools for measuring, searching, changing, splitting, and formatting text. They include functions such as strlen(), strpos(), str_replace(),…
- Excel Split Function: How TEXTSPLIT Returns an ArrayExcel does not have a worksheet function named SPLIT; in Microsoft 365 for Windows, use TEXTSPLIT to divide text at a delimiter…
- Excel String Functions and Operators ExplainedIn Excel, string functions work with text, while operators combine values or compare them. The main text-joining operator is the ampersand (&);…
- Databricks SQL Built-In Functions: Types and ExamplesDatabricks SQL includes a broad set of built-in functions for working with text, numbers, dates, arrays, JSON, aggregates, and more. You can…
- Snowflake String Functions: Examples and Practical UsesSnowflake string functions let you combine, inspect, extract, search, and transform text in SQL. For example, use CONCAT(first_name, ' ', last_name) to…
- Databricks String Functions: A Practical GuideDatabricks string functions are built-in SQL and PySpark operations for cleaning, combining, searching, splitting, and extracting text. In Databricks SQL, you can…
- CATIA Split Function: How It Cuts Parts and SurfacesIn CATIA, the Split function cuts a solid or surface with a selected plane or other cutting element and keeps the side…
- JavaScript Functions: How They Work and When to Use ThemJavaScript functions are reusable blocks of code that perform a task, and W3Schools teaches their syntax, calling conventions, parameters, and return values…
- Excel String Functions: What Each One DoesExcel does not have one function called STRING; it provides a group of text functions for joining, splitting, searching, cleaning, converting, and…
- How to Solve Log Functions Step by StepTo solve a logarithmic equation, first make sure every log argument is positive, then isolate or combine logarithms, rewrite the equation in…
- C++ String Functions: What They Do and How to Use ThemIn C++, string functions are operations such as size(), find(), substr(), and replace() on std::string. If you mean x++, that is not…
- Onshape Split Function: How to Split Parts and FacesIn Onshape, the Split feature divides a part into separate pieces or divides a face into smaller faces. In a Part Studio,…
- End Behavior of Log Functions: Limits and ExamplesThe end behavior of a logarithmic function describes what its outputs do as the input moves toward the edge of its domain…
- C++ String Functions: How std::string Works in PracticeIn C++, string functions are operations for creating, inspecting, searching, and changing text. For most C++ programs, use std::string from the <string>…
- Excel SUBTOTAL Formula for Sum: Examples and TipsTo sum a range with Excel’s SUBTOTAL function, use =SUBTOTAL(9,A2:A20); it sums visible values and automatically excludes rows removed by a filter.…
- Snowflake SPLIT Function: Syntax, Examples & UsageSnowflake’s SPLIT function divides a string wherever it finds a specified delimiter and returns the pieces as an array. Use SPLIT_PART instead…
- Defining Functions in Arduino: Syntax and ExamplesIn Arduino, define a function by writing its return type, name, parameters, and body in C++: for example, int add(int a, int…
- Business Central String Functions: An AL Text GuideIn Microsoft Dynamics 365 Business Central, string functions are AL language functions for measuring, searching, extracting, changing, and formatting text. Common choices…
- Excel SUBTOTAL Average Formula: Syntax and ExamplesIn Excel, use =SUBTOTAL(1,range) to average values while excluding rows removed by a filter. For example, if the numbers are in B2:B6,…
- Databricks SQL Functions: Types, Examples, and UsageDatabricks SQL functions are built-in or user-defined operations you call from SQL to transform values, summarize rows, work with dates and arrays,…
- JavaScript String Functions: Methods, Uses, and ExamplesJavaScript string functions are built-in methods and properties for reading, searching, changing, and dividing text. For example, 'hello'.toUpperCase() returns 'HELLO', while 'hello'.includes('ell')…
- What Is the SPLIT Function in Excel?Excel does not have a worksheet function named SPLIT. In Microsoft 365 and Excel 2024, the function that divides text at a…
- Excel SUBTOTAL Function: Codes and ExamplesExcel’s SUBTOTAL function calculates a chosen summary—such as a sum, average, count, minimum, or maximum—and automatically ignores rows removed by a filter.…
- Oracle XML Functions: Query, Extract, and Generate XMLOracle XML functions let SQL work with XML as data: you can query XML with XQuery, turn selected nodes into relational rows,…
- Oracle SPLIT Function: Split Strings in SQLOracle Database does not provide a general built-in SQL function named SPLIT for turning a delimited string into separate values. If Oracle…
- C++ String Functions: Methods, Examples, and UsageC++ string functions are operations for creating, examining, searching, changing, and converting text. For most everyday work, use the standard-library std::string type…