Formulas & functions
How a function works, with worked examples you can paste.
- Excel String Reverse: Functions, Formulas, and LimitsExcel does not have a built-in worksheet function named REVERSE. With the text in A2, enter =IF(A2="","",TEXTJOIN("",TRUE,MID(A2,SEQUENCE(LEN(A2),1,LEN(A2),-1),1))) in B2 to reverse its…
- C++ String Library Functions and How to Use ThemC++ string library functions are the standard tools for creating, measuring, changing, searching, comparing, and converting text. Most everyday text work uses…
- Split Renal Function Test: What It MeasuresA split renal function test estimates how much each kidney contributes to the pair’s overall function. It is usually a nuclear medicine…
- PL/SQL String Functions: Syntax, Examples, and UsesPL/SQL string functions let you measure, search, extract, change, and format character data; commonly used examples include LENGTH, SUBSTR, INSTR, TRIM, REPLACE,…
- PHP String Handling Functions: Common Uses and ExamplesPHP string handling functions are built-in tools for measuring, searching, extracting, replacing, splitting, comparing, and formatting text. Choose the function according to…
- Split Function in DAX: What to Use InsteadDAX has no built-in SPLIT function. To separate a delimited value, use Power Query’s Split Column feature when you need flexible splitting…
- Ignition System Parts and Functions: A Clear GuideAn ignition system creates and delivers the timed electrical spark that starts combustion in a spark-ignition gasoline engine. Its main parts include…
- Snowflake Split by Delimiter: Functions and ExamplesTo split a string at a delimiter in Snowflake, use SPLIT(string, delimiter); it returns an array of the pieces. For example, SPLIT('north|east|west',…
- SQL SPLIT_PART Function: Syntax, Examples, and AlternativesSPLIT_PART is a SQL function that returns one part of a string separated by a chosen delimiter. In PostgreSQL and Snowflake, for…
- Oracle RIGHT Function: How to Get Trailing CharactersOracle Database does not provide a built-in RIGHT() string function. To return the last characters of a string, use SUBSTR(value, -count); for…
- SPLIT in Snowflake SQL: Functions, Examples, and TipsIn Snowflake SQL, SPLIT(string, delimiter) divides a string wherever a literal delimiter occurs and returns the pieces as an array. Use SPLIT_PART(string,…
- Oracle LENGTH Function: Count Characters and BytesOracle’s LENGTH function returns the length of a character value in characters: for example, LENGTH('Oracle') returns 6. To count bytes instead, use…
- String Handling Functions in C: A Practical GuideC string-handling functions are declared in the standard header <string.h> and work with null-terminated character arrays. The most-used functions measure strings (strlen),…
- GameMaker String Functions: A Practical GML GuideGameMaker string functions let you create, inspect, search, edit, split, and format text in GML. The essentials include string() for conversion, string_length()…
- Snowflake MID String Function: Extract Text with SUBSTRSnowflake’s MID function extracts part of a string by position; it is a synonym for SUBSTR (also called SUBSTRING). Use MID(string, start_position,…
- SQL String Replace Function: Syntax and ExamplesUse SQL’s REPLACE function to find every occurrence of one text value inside another and substitute different text: SELECT REPLACE('blue car', 'blue',…
- C++ String Functions Cheat Sheet: Uses and ExamplesA C++ string functions cheat sheet centers on std::string: use size() or length() to count bytes, find() to search, substr() to copy…
- ColdFusion String Functions: Use, Syntax, and ExamplesColdFusion string functions let you measure, search, compare, split, and change text in CFML. Common choices include Len, Find, Mid, Replace, Trim,…
- Oracle SQL Left String Function: Use SUBSTR InsteadOracle SQL does not provide a built-in LEFT() string function. To return the first characters of a value, use SUBSTR(value, 1, length);…
- Oracle Database String Functions: Guide and ExamplesOracle database string functions let you measure, extract, search, compare, format, and change text in SQL. Common choices include LENGTH, SUBSTR, INSTR,…
- Oracle LEFT Function: How to Get Text from the LeftOracle SQL does not provide a built-in LEFT() function. To return the first characters of a string, use SUBSTR(string, 1, number_of_characters); for…
- Function in Function in JavaScript: Examples & UsesA function inside another function in JavaScript is a nested function: it is defined within the outer function’s body and can use…
- Visual Basic String Functions: A Practical GuideVisual Basic string functions help you measure, search, extract, compare, change, and split text. In VBA, functions such as Len, Mid$, InStr,…
- Rust String Functions: Methods, Examples, and TipsRust handles text mainly with the growable, owned String type and the borrowed string slice &str. Their methods let you create, append,…
- C String Functions: How They Work and When to Use ThemC string functions are standard library routines declared in <string.h> for measuring, copying, comparing, joining, and searching strings. They operate on character…
- Lua String Functions: A Practical Guide to Working With TextLua’s string functions are provided by the built-in string library: use functions such as string.sub to extract text, string.find to locate a…
- Python String Functions: Methods, Examples, and UsesPython string functions are mainly string methods—operations such as upper(), strip(), replace(), and split() that work on text. W3Schools’ Python string reference…
- Oracle SQL Split Function: How to Split Text into RowsOracle SQL has no single SPLIT() function that works portably across releases and installations. For ordinary delimited text, use REGEXP_SUBSTR to extract…
- Python String Functions: Examples and a Simple ProgramA Python string function program uses built-in string methods and functions such as strip(), lower(), split(), and len() to work with text.…
- Java String Functions: Methods, Examples, and GuideOn W3Schools, “Java string functions” refers mainly to methods of Java’s String class, such as length(), toUpperCase(), indexOf(), and replace(). These methods…