Description | The |
Syntax | REGEX_REPLACE( |
Output | text |
Variables
text
: The input text string in which you want to perform replacements.pattern
: The regular expression pattern used to identify the text to be replaced.replacement
: The text that you want to replace the matched text with.
Example
REGEX_REPLACE(`Original Text`, "[^a-zA-Z0-9 ]+", "")
ID | Original Text | REGEX_REPLACE |
1 | Hello, World! | Hello World |
2 | Example123: 456789 | Example123 456789 |
3 | Remove! Symbols? From Text! | Remove Symbols From Text |