syntax:functions:commonsubstring
Table of Contents
CommonSubstring(text1, text2)
Category: Text function
Description
This function returns the longest substring common to both text1 and text2.
Arguments
| Argument | Type | Description |
|---|---|---|
| text1 | Text | Any text, or value that can implicitly converted to text. |
| text2 | Text | Any text, or value that can implicitly converted to text. |
Return value type: Text
Remarks
This function is case sensitive.
Examples
commonsubstring( "Bicycle DX-349 black", "Velo DX-349 noir" ) //Returns " DX-349 " (note leading/trailing spaces)
commonsubstring( "Bob", "David" ) //Returns empty value (no common strings found)
See also
syntax/functions/commonsubstring.txt · Last modified: 2024/10/21 12:22 by craigt