Difference between revisions of "REPLACE"
From AgileApps Support Wiki
imported>Evelyn m |
imported>Aeric |
||
| Line 4: | Line 4: | ||
REPLACE('string', 'searchString', 'replacementString',) | REPLACE('string', 'searchString', 'replacementString',) | ||
{{:Common:CaseSensitiveSearchString}} | |||
;Return:[[string|Text string]] | ;Return:[[string|Text string]] | ||
Revision as of 00:51, 4 June 2014
The REPLACE function searches for a string within a target string. If the search string is found, the replacement string is substituted for the search string.
- Syntax
REPLACE('string', 'searchString', 'replacementString',)
Note:
The searchString is case-sensitive. For a case-insensitive search,
use the LOWER function on both the search string and the string being searched.
- Return
- Text string
- Example
REPLACE('quick', 'ic', 'ar') = 'quark'