Formulas & functions
How a function works, with worked examples you can paste.
- MATLAB split Function: Syntax and ExamplesMATLAB’s split function separates text into pieces at a delimiter and returns the pieces as a string array. Use parts = split(text,…
- Arduino String Functions: Methods, Examples, and TipsArduino string functions are methods for working with text stored in the Arduino String class: for example, length() measures a string, indexOf()…
- JavaScript split() Function: How to Split a StringUse JavaScript’s split() method to divide a string into an array of smaller strings: call it on the text and pass the…
- JavaScript String match(): How It Works and When to Use ItJavaScript’s String.prototype.match() method searches a string using a regular expression and returns information about the match, or null if it finds none.…
- String Functions in C: What They Do and How to Use ThemString functions in C are library routines, declared in <string.h>, for measuring, copying, joining, comparing, searching and splitting strings. A C string…
- Split CSV in Excel: Choose the Right MethodIf you mean splitting CSV data in Excel, use Data > From Text/CSV to import it and choose the correct delimiter; for…
- String Functions in MATLAB: A Practical GuideMATLAB string functions let you create, inspect, search, split, join, format, and modify text. For most new code, use string arrays, written…
- Godot String Functions: A Practical GDScript GuideIn Godot, string functions are methods on the GDScript String type, used to search, split, clean, format, validate, and convert text. For…
- PySpark Split Function: Syntax, Regex, and ExamplesIn PySpark, pyspark.sql.functions.split() divides a string column wherever a regular-expression pattern matches and returns an array of strings. For example, F.split(F.col('line'), ',')…
- SAS String Functions: A Practical GuideIn SAS, string functions are character functions used to inspect, extract, join, clean, and transform text; there is no single function called…
- Oracle SQL String Aggregate Functions: LISTAGG GuideOracle SQL’s main string aggregate function is LISTAGG: it combines values from multiple rows into one delimited string, either for each group…
- Snowflake SQL String Functions: Examples and Usage GuideSnowflake SQL string functions let you combine, inspect, search, split, extract, and clean text values in queries. Common choices include CONCAT or…
- Split Function in C++: Options and ExamplesC++ does not have a general-purpose std::split function or a split() member on std::string. In C++20, you can split a range with…
- SQL String Functions and Operators: A Practical GuideSQL string functions transform, inspect, search, and format text; string operators combine text or compare it with patterns. Common tools include UPPER,…
- JavaScript Functions: How They Work and When to Use ThemIn JavaScript, a function is a reusable block of code that can receive values, perform work, and optionally return a result. Functions…
- SQL Server Split Function: STRING_SPLIT ExplainedSQL Server’s built-in split function is STRING_SPLIT, which turns a delimited string into a table of values. Use it in a FROM…
- Apex String Functions: Common Methods and ExamplesIn Salesforce Apex, “string functions” usually means methods on the built-in String type. Use methods such as trim(), contains(), substring(), replace(), and…
- Range of Log Functions: What It Means and How to Find ItThe range of the basic real logarithmic function f(x) = logb(x) is all real numbers, or (−∞, ∞), provided the base satisfies…
- SQL SPLIT Function Syntax and Examples by DatabaseSQL has no single, universal SPLIT() function: the syntax depends on your database, and some systems return pieces as rows while others…
- PostgreSQL String Functions: Practical Uses and ExamplesPostgreSQL string functions let you join, inspect, extract, search, and transform text directly in SQL. Common choices include concat and || for…
- Databricks SQL Window Functions: Syntax and ExamplesDatabricks SQL window functions calculate a value across related rows while keeping each input row in the result. Use the OVER clause…
- Excel SPLIT Function: Access and AlternativesExcel does not have a worksheet function named SPLIT. In Microsoft 365 for Windows, use TEXTSPLIT to separate text with a formula;…
- SQL Server String Functions: A Practical GuideSQL Server string functions let you inspect, search, extract, combine, replace, and format text in queries. The most useful include LEN, SUBSTRING,…
- Power Automate Split Function: Syntax and ExamplesIn Power Automate cloud flows, split() divides a text string wherever a specified delimiter appears and returns the resulting pieces as an…
- Calculator With Log Functions: How to Choose the Right OneA scientific calculator with log functions can calculate common logarithms (log base 10), natural logarithms (ln, base e), and often logarithms in…
- MySQL String Functions: Examples, Uses, and Common IssuesMySQL string functions operate on text values to join, inspect, extract, search, and modify strings. Common examples include CONCAT() for combining values,…
- Databricks User-Defined Functions: How They Work in PracticeDatabricks user-defined functions (UDFs) let you apply custom logic to data in SQL or Spark when built-in functions do not meet the…
- SOLIDWORKS Split Function: Dividing Parts into BodiesIn SOLIDWORKS, the Split feature divides one part into multiple bodies using a plane, face, surface, or sketch as a cutting tool.…
- T-SQL String Functions: Uses, Examples, and Common IssuesT-SQL string functions are built-in SQL Server tools for finding, extracting, changing, combining, measuring, and formatting text. Common choices include CONCAT to…
- SQL Functions in Snowflake: Types and ExamplesSQL functions in Snowflake are built-in or user-defined operations that take values as input and return a value or set of rows.…