Function reference
Replaces all occurrences of a string with another string. (Non case sensitive)
*ReplaceAll ( string1 , searchfor , replacewith )
Argument | Description |
string1 | The string in which you want to replace searchfor with replacewith. |
searchfor | the string to replace. |
replacewith | the string to use as replacement. |
Data type: String
Example 1
This expression returns 1xyz2-1xyzbc2
ReplaceAll(‘1A2-1abc2’ ,‘a’ , ‘xyz’‘)
Last modified:
23 May 2021