Formulas & functions
How a function works, with worked examples you can paste.
- 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,…
- SQL String Functions: W3Schools Guide and ExamplesSQL string functions work with text values: they can join strings, change letter case, extract part of a value, find text, or…
- JavaScript: How to Pass a String to a FunctionPass a string to a JavaScript function by placing it inside the function call’s parentheses: greet('Maya'). The function receives it through a…
- SQL Server String Functions and How to Use ThemSQL Server string functions let you measure, search, extract, combine, replace, and format text in a query. Common choices include LEN, SUBSTRING,…
- SAP HANA String Functions: Syntax and ExamplesSAP HANA string functions manipulate text in SQL: they join strings, extract parts, find characters, change case, remove spaces, and replace text.…
- SQL String Aggregate Functions: GROUP_CONCAT, STRING_AGGSQL string aggregate functions combine values from multiple rows into one text value, usually once per group. Use a function such as…
- ArcGIS Arcade String Functions: Names and ExamplesArcGIS Arcade string functions are built-in tools for finding, joining, extracting, replacing, and changing text in an expression. The core functions include…
- Java String Handling Functions: Methods and ExamplesJava string handling is mainly done with methods on String; use StringBuilder for repeated changes, regular-expression classes for pattern-based work, and charset…
- Java String Predefined Functions: Methods and ExamplesJava’s predefined string operations are methods of the String class, not standalone functions. Common examples include length(), charAt(), substring(), equals(), contains(), and…
- C++ Sort for Multiple Strings: Syntax and ExamplesTo sort multiple strings in C++, put them in a container such as std::vector<std::string> and call std::sort(strings.begin(), strings.end()), including <algorithm>. By default,…
- C++ String Built-In Functions and How to Use ThemC++ does not have a special set of built-in functions devoted to strings: its everyday string type is the standard-library class std::string,…
- W3Schools String Functions in JavaScript ExplainedOn W3Schools, “string functions” usually means JavaScript string methods: operations such as searching, replacing, slicing, and changing the case of text. In…
- C++ String to Integer: Functions and Safe ParsingIn C++, use std::stoi to convert a string to an int; it is declared in the <string> header. For example, int value…
- Python String Functions: Methods, Examples, and UsagePython string functions are tools for creating, inspecting, searching, and changing text. Most text operations are methods called on a string, such…
- C String Manipulation Functions: A Practical GuideC string manipulation in standard C is provided mainly by functions declared in <string.h>, including strlen, strcpy, strcat, strcmp, and search functions…
- MS Access Split Function: Syntax and ExamplesYes. Microsoft Access’s VBA Split function divides a string into a zero-based array of smaller strings wherever it finds a chosen delimiter.…
- Oracle SQL Developer String Functions and ExamplesOracle SQL Developer does not have a separate set of string functions: it is the database tool where you write and run…