Formulas & functions
How a function works, with worked examples you can paste.
- SOLIDWORKS Split Function: How to Split Part BodiesUse the Split feature to divide a solid body in a SOLIDWORKS part with a plane, surface, face, or suitable sketch. Open…
- Power Automate Split Function Syntax, Uses, and ExamplesIn Power Automate, use split(text, delimiter) to divide a string wherever the delimiter occurs; the result is an array of text values.…
- SQL Server 2019 String Functions: Uses and ExamplesSQL Server 2019 includes string functions for joining, searching, trimming, measuring, changing, and extracting text. Common choices include CONCAT and STRING_AGG for…
- Oracle SQL String Functions: Syntax, Uses, and ExamplesOracle SQL string functions operate on character values to search, extract, combine, change, and format text. Common choices include SUBSTR and INSTR…
- SQL LEFT Function: Syntax, Examples, and DifferencesSQL’s LEFT function returns a specified number of characters from the beginning of a string. For example, LEFT('Database', 4) returns 'Data' in…
- SPLIT Function in Snowflake SQL: Syntax and ExamplesSnowflake’s SPLIT function divides a string wherever an exact separator occurs and returns the pieces as an array. Use SPLIT(string, separator); for…
- Microsoft Access Split Function in Queries: How It WorksIn Microsoft Access, Split is a VBA function that breaks a string into an array using a delimiter, such as a comma…
- Split Function Renal Scan: Purpose and ResultsA split function renal scan is a nuclear medicine test that estimates how much each kidney contributes to the pair’s overall kidney…
- Excel Split Function: How TEXTSPLIT Splits Text in CellsExcel does not have a worksheet function named SPLIT; in Microsoft 365 and Excel 2024, use TEXTSPLIT to divide text into separate…
- Excel Built-In String Functions and How to Use ThemExcel has built-in string functions—usually called text functions—that let you extract, search, clean, change, combine, and split text in cells. For example,…
- Databricks SQL SPLIT Function: Syntax and ExamplesIn Databricks SQL, split(str, regex [, limit]) divides a string wherever it matches a regular expression and returns the pieces as an…
- SQL String Split Function: Syntax by Database EngineThere is no single SQL string-split function that works in every database: SQL Server uses STRING_SPLIT, PostgreSQL commonly combines string_to_array with unnest,…
- Java 8 String Functions: Common Methods and ExamplesIn Java 8, “string functions” usually means methods on the String class, such as length(), substring(), contains(), and replace(). Java 8 also…
- Oracle Java String Functions ExplainedIn Oracle-related Java code, string operations usually mean methods on Java’s built-in String class, such as length(), substring(), contains(), and replace(); they…
- C++ String Member Functions: A Guide to std::stringC++ string member functions are operations provided by std::string for examining, searching, changing, and accessing text. The most-used include size(), empty(), find(),…
- C# String Functions: A Practical GuideC# string functions are methods and properties on the built-in string type, also called System.String. Common choices include Length for the number…
- C String Functions: What They Do and How to Use ThemC string functions are library routines for measuring, copying, joining, comparing, searching, and splitting null-terminated character sequences; most are declared in the…
- ZN Function in Tableau: What It Does and When to Use ItIn Tableau, ZN(expression) returns the expression’s value when it is not null, and returns 0 when it is null. It is a…
- PHP String Functions: How They Work and When to Use ThemPHP string functions let you inspect, search, split, replace, format, and escape text. A PHP string is a sequence of bytes, so…
- Tableau IF Function: Syntax and Practical ExamplesIn Tableau, IF is a conditional expression that returns a value when a condition is true, with optional alternatives for other conditions.…
- PHP String Functions: How to Work With Text SafelyPHP string functions let you inspect, search, change, split, join, and format text. Common choices include strlen() for byte length, strpos() for…
- Oracle String REPLACE Function: Syntax and ExamplesOracle’s string replacement function is REPLACE: use REPLACE(source, search_text, replacement_text) to replace every occurrence of one literal substring with another. For example,…
- Oracle MAX Function on Strings: What It Returns?Oracle’s MAX function works on character values: it returns the string that sorts highest among the non-NULL values in the input. For…
- Databricks SQL String Functions: Uses and ExamplesDatabricks SQL string functions let you join, search, extract, split, compare, and clean text values directly in a query. Common choices include…
- Toad Oracle String Functions: Syntax and Examples in SQLToad for Oracle does not have a separate set of string functions: it sends your SQL to an Oracle database, which provides…
- Arduino Pass String to Function: Examples, Types, and SafetyYes. In Arduino C++, pass a String to a function by putting its type in the parameter list, such as void showMessage(const…
- Oracle String Aggregation Functions ExplainedOracle’s main string aggregation function is LISTAGG: it combines values from multiple rows into one delimited string, with an explicit order. For…
- Excel PMT Function for Mortgage PaymentsUse Excel’s PMT function to estimate a fixed, regular mortgage payment for principal and interest. For a $300,000 loan at 6.5% annual…
- JavaScript String startsWith() Function: How It WorksYes. JavaScript provides the string method startsWith() to check whether a string begins with a specified sequence of characters. It returns true…
- SQL String Functions: Four Common ExamplesFour useful SQL string functions are UPPER, LOWER, CONCAT, and a length function such as LENGTH. They change letter case, join text,…