MatchAndReplace

Description

Returns a new string in which occurrences of text between a specified start string and end string are replaced with another specified string. 

Signature

MatchAndReplace(
  'inputstring',
  'startmatch',
  'endmatch',
  'replacementstring',
  'retainmatchers',
  'replacementcount'
)

Example 1

MatchAndReplace('111{xxx}222{yyy}', '{', '}', 'ooo')
 Returns '111ooo222ooo'  

Example 2

MatchAndReplace('111{xxx}222{yyy}', '{', '}', 'ooo', true)
 Returns '111{ooo}222{ooo}'  

Example 3

MatchAndReplace('111{xxx}222', '{', '}', 'WW SuperCool($0) WW')
 Returns '111 SuperCool(xxx) 222' 

Example 4

Search MatchAndReplace for more examples