Category: Text function
This function returns the longest substring common to both text1 and text2.
| 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
This function is case sensitive.
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)