RegReplace function

Text category - Regular Expressions family Home 
What the name means"Do a search and replace"
SyntaxRegReplace ( Textstring, RegSought, Replacement, [CaseInSensitive] )
Description
See AlsoRegMatchWhole (Textstring, RegSought, [CaseInSensitive])
RegSplit (Textstring, RegSought, [SplitMode], [CaseInSensitive])
VariableType or ValueDescription
Inputs: (4)
1 Textstring String A string of text
2 RegSought String Regular Expression pattern to seek
3 Replacement String Replacement string to substitute
4 CaseInSensitive Boolean (Optional) Whether you want the evaluation to be case insensitive (default: case sensitive). This will simply convert Textstring and RegSought to lower case before evaluating. (Optional)
Output:
Return Value ResultText String The result of the function (a text value)
Defaults and Values

The variable(s) of this function have certain defaults and/or switch values associated with them. Click here to see more.

Features

This function has a few features that help explain its name. Click here to see more.

Examples
  • Preview of the RegReplace example.
  • The above spreadsheet can be accessed from the Quick Reference (on the Business Functions menu), on the Examples menu, or in the Business Functions\Component Examples directory