syntax:functions:removetext
Table of Contents
RemoveText(text, string)
Category: Text function
Description
This function removes all instances of string from text.
Arguments
Argument | Type | Description |
---|---|---|
text | Text | Any text value from which the text string is removed. |
string | Text | The text string removed from text. |
Return value type: Text
Remarks
This function is case sensitive.
Number values entered for text and string are implicitly converted to text.
All instances of string are removed from text.
If string is not found within text, the full value of text is returned.
Examples
removetext('Miss Mississippi', 'iss') //Returns 'M Mippi'
removetext('Wellington', 'well') //Returns 'Wellington' ('well' not found due to case; text value is returned)
removestart(123456123, 123) //Returns '456' (Numbers implicitly converted to text; return value is text)
See also
syntax/functions/removetext.txt · Last modified: 2021/08/15 02:54 by craigt