Function reference
Replaces the first occurrences of a string with another string. (Non case sensitive)
*ReplaceFirst ( 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-1abc2
ReplaceFirst(‘1A2-1abc2’ ,‘a’ , ‘xyz’‘)
Last modified:
26 August 2025